Needing a formulat to append data from one tab to another

[Jaimee001]

Hi everyone, I have 2 reports. Report A has a bunch of data columns (actually a lot of columns and 1000 rows). Report B is a revenue report by month January through May. Each report has the account number in common. I need to take the monthly revenue and append those columns to report A. The example I'm sending has 2 tabs to represent each report. I'm thinking in the data tab, in the column for January, I would enter a formula and copy it down to get all of the January data and then follow suit for February, March, April and May.


Here is the link: http://speedy.sh/qDFh2/Append-Data-from-one-sheet-to-another.xlsx


I hope this makes sense...if not, please let me know any questions you may have.

Thank you in advance

 

[Smallman]

Hi Jaimee


I think the reason your question has 'sat on the shelf' is because your sheet "What I want" or has no data on it. Just colours! I could assume you want week and Date data but other than that I have no clue and I suspect I am not alone. In future if you post include your raw data with the end result. Data not just the hint of the data.


The approach you would take to solve this could vary greatly based on your results sheet.


Take care


Smallman