I am working with 4 seperate workbooks where 4 different people enter data into cells.
I have a 5th workbook that needs to have all the data from the 4 individual workbooks bought across so I can see all data. Like a master file.
basically, in each cell of the master, I have the following code.
=IF('[loans - 0708 - officer 01.xls]07-08'!B5="","",'[loans - 0708 - officer 01.xls]07-08'!B5)
I then have the code for each officer.
As there are 24000 lines collectively for the financial year, the size of my master is 37mb, even when its empty, obviously cause each cell still have a formular in it.
Is there ANY way to copy across the data from other workbooks without having to have every single correpsonding cell have this kind of formular to view the code? Also, copy it without having to open the other workbooks.