This is my first post so please bear with me. I am a fairly novice excel user so require assistance.
I have 1 spreadsheet with about 400 products I currently purchase from one Chinese supplier. I use this spreadsheet as a purchase order for my supplier. All of the table headings are product code, cost price, master box quantity etc.
I have found some of my current products from other suppliers at a cheaper price so therefore what I would like to do is have an additional worksheet but copy the original product codes from the 1st worksheet, add supplier details and their respective product codes within columns for the alternative suppliers, along with their cost prices. What I want to know is there a way where my current supplier can only see the 1st worksheet?
apologies if this seems a simple question but as I said I am a novice.
Bookmarks