Excel linking data question
Posted on 2011-03-04
Hi, i have an excel spreadsheet (SHEET1) which our customers use to track sales etc. I want to create and maintain a MASTER spreadsheet which would hold things like budgets, Float amounts etc which would feed data to SHEET1, so everytime we need to change something for a customer (like a waste budget), we would change the MASTER spreadsheet which would then change the customers spreadsheet.
The problem with this idea is that i want to use EXACTLY the same SHEET1 spreadsheet for all our customers. Obviously this wouldn't work as Sheet1 would need to get SPECIFIC data for the SPECIFIC customer.
Is there a way that i could enter the customer number in SHEET1 (in cell A1), then have multiple worksheets in the MASTER sheet (named as each customer no.) which would contain details for each customer. Then SHEET1 linking to MASTER / [CUSTOMER NO.] TAB (getting the customer no from cell A1)
Can anyone tell me if this is possible please? maybe using a VBScript??