Stock values linked to physical stock on seperate sheet

Hi,

I'm new to this and did try a search before I posted. Basically I have a couple of shops and have made a spread sheet that the shop managers will use for ordering. It has stock level, versus physical stock which gives them the order quantity. What I want to do is have (preferably hidden from them) each item of stock with a value against it so I can view the financial amount of stock I am carrying at any one time. I don't know if I need to do a separate sheet to keep it private from the staff and copy/paste data weekly, I would also like to put cost price AND retail price if possible. Thanks in advance

Andy

Hi Andy welcome to the forum.
Plz post a sample file and your desired result, for better understanding of your requirement.

Hi Andy and welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Dear andy,
Plz see the attached file. In sheet 1 copy all the details of shops in the given format, and in price master update the cost price and retail price as required, and see the summary sheet.
Hope this will help.

Thank u for your feedback. You can add what you wish for. If you find any errors/difficulties i would be grateful to help you.
If you have your desired result, plz click on the star to add to my reputation, and mark this thread as solved.

Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.