Help with using a series of values to fill a stocksheet

[john dalton]

Hi,

I have created a stocksheet that uses a stock movement sheet as an input method, I need the main data sheet to read the stock movement sheets data by period and create a running total of goods in and goods out as indicated by the period header.

please find attached a copy of the spreadsheet

[MarvinP]

Hi John,

Find the attached where I did a Pivot Table with Running Totals on your data. I believe the data needs to have initial numbers in stock somewhere in the data list and then move the increase in stock numbers to the same column.

This is just another way that may work for you. Play with Pivot Tables a while as they have Running Totals and you can filter and group by date. See if this helps

[john dalton]

Thanks but i cant do it as a pivot table need to do it as a forumla to put into issues and deliveries/returns on the data sheet - possibly with Index and match function any ideas?

[john dalton]

Hi sorry the attached spreadsheet wasnt working properly please see the new attached sheet it should be working properly now

[MarvinP]

Hi John,
In 2007 Excel there is a SumIfs function that takes multiple criteria but in 2003 we need to go to a SumProduct Function.

In N3 put this formula and pull down.

Please Login or Register  to view this content.

[john dalton]

Tha works a dream mate cheers

[john dalton]

This is a stupid question but how do you place a thread as solved