excel help please!!

Hope someone can help with this one...

I'm co-ordinating the company stocktake this weekend. I have two excel files, one called "Suppliers Master" and one called "Stocktake Master". The stocktake master file has each department's stock quantities listed, and the price in each worksheet is linked to the Suppliers Master file. Next week, I'll get all the paperwork back from the departments and have to manually enter the stock quantities in their worksheet.

I want to make sure I "freeze" the prices in each stocktake worksheet at this weekend's prices, but will need to carry on working with new supplier invoices before the accountants have finished with the Stocktake file.

I wondered if I was to create a copy of Stocktake Master, would the new file just have the prices in and not the links? I tried it at home with a quick mock-up, but we run Open Office, not Excel, so I'm not sure if Excel will carry the link over.

Thanks for any help!

Comments

Sign In or Register to comment.