Stock Control in Excel

[MarkAdz]

Hi there, I am a newbie on the site. I have a question for the clever people...

Is it possible in Excel to create a stock control sheet pulling the info from an invoice also created in Excel. ie I have the initial stock in excel sheet, when an item is sold, it updates the stock sheet from the invoice?

Hope this makes sense...

Thanks for you assistance!

 

[MarkAdz]

I did try the step... Worked perfect! Yes I mean from more than one invoice.

 

[BenMiller]

There is no simple way to do it with the way your data is set up now. You'd have to do a separate VLOOKUP for each invoice - and being that you're constantly adding invoices, you'd have to keep changing the existing formulas. Obviously not an option.

There really, really has to be one centralized place with all your sales data: In other words, a summary of all the invoices; maybe even just a total.

 

[MarkAdz]

I think I have a solution. Have the invoices on one separate workbook with different sheets, BUT with a summary page in front from which the stock sheet gets info.... The front sheet's formula would look similar to one you have sent me. Do you think this can work? I'll play around with it and see what I can come up with!

Thank you so much for your help! Have a good afternoon! Good night from South Africa!

 

[BenMiller]

It could work but again, if you keep adding sheets you'll want to summarize all the sheets. This might help you.

http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm