shadows200354
New Member
- Joined
- Feb 16, 2016
- Messages
- 11
Hi all,
I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information.
The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase order and their current state, Open, partial open or closed and total PO value. The second table gives me the dept. code and nominal code and if the PO is split between different department/nominals their individual values.
what i have done so far is I am able get the data by department and nominal for the open and partial POs, using sumifs, in two separate datasets on a different sheet. (1 data set shows PO split by dept, and the other by nominal same PO)
I need a way of transferring this data from this sheet through a look up into another workbook/ sheet. where the data is limited by dept and nominal on the side. you take the data straight from the data dumps if needed.
I have attached an example and labelled the tabs accordingly. Tab "data transfer layout tab" would be destination tab. "current sumifs tab" is where the sumifs are kept, this is an example
There are 999 departments and 250 nominal codes and Say 16000 PO numbers.
Dropbox link attached Dropbox - sent to test.xlsx. Any help would be greatly appreciated.
I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information.
The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase order and their current state, Open, partial open or closed and total PO value. The second table gives me the dept. code and nominal code and if the PO is split between different department/nominals their individual values.
what i have done so far is I am able get the data by department and nominal for the open and partial POs, using sumifs, in two separate datasets on a different sheet. (1 data set shows PO split by dept, and the other by nominal same PO)
I need a way of transferring this data from this sheet through a look up into another workbook/ sheet. where the data is limited by dept and nominal on the side. you take the data straight from the data dumps if needed.
I have attached an example and labelled the tabs accordingly. Tab "data transfer layout tab" would be destination tab. "current sumifs tab" is where the sumifs are kept, this is an example
There are 999 departments and 250 nominal codes and Say 16000 PO numbers.
Dropbox link attached Dropbox - sent to test.xlsx. Any help would be greatly appreciated.
