Hi Team,
Is anyone able to help me please? It would be very much appreciated and save me a lot of time and headaches!
Please see example worksheet I have attached.
There are 3 tables on the same sheet. I want to merge the the data from the table 2 and 3 into table 1, as follows:
I want to deduct the data from the table in columns F&G from the table in column A&B, for example, cell B637 will then show the value -15 etc...
I then want to add the data in table J&K to to the the table in column A&B, for example, cell B133 will then show the value 22 etc....
We can ignore the values in column C for the exercise.
Please feed back any questions, and as I said I very much appreciate your expert help.
Thanks
Richard.
Bookmarks