Okay, no problem! Thanks!!
I have a vlookup in column B which works perfectly well on the master sheet but when the data is automatically copied over... The information in column B isn't written and I get a #REF!
in the cell...
When I click on the cell to see what's going on... This is what I see in the formula bar... =VLOOKUP(A2,DataSource!#REF!,2,FALSE)
I guess the vlookup formula isn't being copied over??
Also... When a new row is inserted automatically below on the master sheet, the vlook formula isn't being copied down either.
Any ideas?
Bookmarks