I have two spreadsheets one is 2 columns x 200 rows the other master sheet is 250 columns x 500 rows, the master spreadsheet performs vlookup on the smaller one
My problem is that the master sheet will not fully update (some cells do) unless I press F2 on each cell this then brings up a box as though you were going to open a file although it says Update values: in the top right of the box. I then have to select the file I'm trying to update from (there are a quite a few!) - am I asking too much of the file or (more than likely) what have I done wrong?
Hoping someone can help
Thanks,
Moll
My problem is that the master sheet will not fully update (some cells do) unless I press F2 on each cell this then brings up a box as though you were going to open a file although it says Update values: in the top right of the box. I then have to select the file I'm trying to update from (there are a quite a few!) - am I asking too much of the file or (more than likely) what have I done wrong?
Hoping someone can help
Thanks,
Moll