Hi,
This problem has haunted me for years but I would like to find a solution...
I use SAP and in order to get the actuals extracted from SAP I have to copy and paste them in which takes me days to do so wondered if there is an easier way?
On the attached file I have two tabs. “Data Dump” is the extract from SAP and “P&L” which is a profit and loss template which is where I need the data input to.
Is there any way I can use formula on the P&L tab which pulls the data from the dump based on the following:
- MATCH Colum B on the “Data Dump” sheet with column A “P&L”
- MATCH Colum C on the “Data Dump” sheet with column B “P&L”
- MATCH Colum F on the “Data Dump” sheet with Row 4 on the “P&L” This would need to be grouped if this is even possible?
All the entries on the Dump should go in to column M (Jan 13) as they are all January entries, this will not always be the case as in this example.
I am open to any suggestions of how best to achieve this if it can be done?
I have attached a file for reference
Bookmarks