We (my department) need to have an easier way to quote an item within one workbook rather than opening and closing 3 or 4 spreadsheets.
I moved everything to one workbook and i have (4) sheets - and I am grabbing information from sheet 1, sheet 2 and sheet 3 and compiling that information on sheet 4. It works. I filled down using the formulas - and that works. This is where i'm not sure what to do to fix my issue. The issue is that once i make a chance on page one, ALL the fields change.
What i need to do is fix it so once i save the most recent entry/quote, it does not change the next time I need to calculate another quote - or change any of the parameters on sheet 1, 2 or 3.
I hope this makes sense. If not, just let me know and I'll try to clear thing up.
Thanks,
Mike
Bookmarks