Pasting new data and formulas stop working

Kubi · #1 07-07-2017, 12:24 AM

are you just wanting to return a value from sheet 1 without looking through it? perhaps try using a VLOOKUP for example

=VLOOKUP(A6,Sheet1!A1

10,4,0)

ehmo · #2 07-07-2017, 12:31 AM

I delete the data on sheet1 and then add the data with different numbers again. After pasting new data it just show #REF on the formula sheet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Workbook Stop Working When Run VBA	GeoKoro13	Excel Programming	1	12-01-2016 04:03 AM
VBA to gather data from one workbook and pasting it in a data set	lwbarnes	Excel Programming	1	11-02-2016 07:05 PM
All Office products stop working	lethlean	Office	1	05-18-2013 07:07 AM
Save As cause app to stop working	rafterman	Word	1	03-04-2013 11:20 PM
GIF's stop working	Kwarior	PowerPoint	3	03-17-2010 09:59 PM