I work for an IT company who build their own PC's. And we use a simple Excel 2003 spreadsheet to piece-together and price-up PC's for retail, I've attached an example of the spreadsheet for you to see. It uses basic formulas so we can see at-a-glance things like VAT figures, margin, profit etc. Each PC we sell is contained within one Excel file, and each PC has it's own Workbook tab.
The problem I want to solve is whenever we change a component or price, we have to do each system manually, which gets very repetetive and time consuming.
What I'd like to be able to do is change the price of, let's say, the motherboard, and have the price be reflected across each of the PC's using that same motherboard on each seperate tab. This same system would apply when we change a product name, product ID etc.
How would I achieve this?
(SEE ATTACHED FILE)
Last edited by VBA Noob; 03-01-2009 at 11:42 AM.
A good way is to use a separate lookup list and the VLOOKUP function to pull back the current values. See the attachment for an example.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
Re: How do I link cell contents across worksheets?
Great! Thank-you very much, that seems to do the trick, but I just need to spend some time looking over it to fully head my head round the formulas, I'm not familiar with how the VLOOKUP function worksI'll have to study it... thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks