Picking certain data from Spreadsheet A and converting it to Spreadsheet B

**Trebby** · 03-23-2012, 01:29 PM

Hi Guys,

I was wondering if you could help please.

I have two spreadsheets (Workbooks),

Spreadsheet (Workbook) A is my data entry sheet and is split by commodity. Within each commodity TAB (worksheet) you have depots, months, invoice net value.

Spreadsheet (Workbook) B is my summary spreadsheet split by depot.

The problem I currently have is that I'm having the enter the data twice as it's split into different sections.

Idly I'm looking to have a formula in spreadsheet B that picks the month, along with the depot and it's nett amount from spreadsheet A and places everything into the right commodity/monthly cells.

For example;

Spreadsheet (Workbook) A

http://uploadpic.org/v.php?img=nPIjGaDArX

Spreadsheet (Workbook) B

http://uploadpic.org/v.php?img=0gCkce1R9Y

I want the Workbook A depot columns K to O to work with column E to then go into Workbook B and D,N 294-304.

Apologies for the layout, and thanks for you help.