Here is my problem:
I would like excel to pull data from one spreadsheet to another spreadsheet in the same work book. I am using the VLOOKUP formula to do this. I would like to pull the formula across the cells horizontally and automatically pull this data for each new year in the new excel sheet. However, I cannot currently do this and it is taking me an exorbitant amount of time to complete this work.
As can be seen in the picture below, I want to take data from DA DATA and bring it into my new spreadsheet "Development Assistance" by pulling vlookup accross my spreadsheet. Please help.