I have been trying to work this out for hours but cant seem to solve the problem.
I am trying to extract data from 7 different tables (Rent, Fit out, Dilaps etc) into one consolidated table (AC474:CK676)
The idea is that it brings in the information for each separate tenant- in this case there are 12.
The problem I seem to be having is that from Line 585 on wards it still seems to be picking up data in the Rent line even though it should be empty
Can anybody be kind enough to spot my error- Thanks
I am trying to extract data from 7 different tables (Rent, Fit out, Dilaps etc) into one consolidated table (AC474:CK676)
The idea is that it brings in the information for each separate tenant- in this case there are 12.
The problem I seem to be having is that from Line 585 on wards it still seems to be picking up data in the Rent line even though it should be empty
Can anybody be kind enough to spot my error- Thanks