Quote Building Question

[Guest]

I have a large inventory Spread sheet with products on different workbook
tabs ie Servers,Desktops,UPS etc. Each line has Qty, Description, ITem Price
and total price. I want to be able to put a quantity value in column A on
certain rows in each tab and have them brought over to a single proposal page.

Any suggestions

 

[Susan]

well, you could have a summary/proposal page with formulas to
automatically calculate stuff as the quantities are entered,
& then enter it on the summary/proposal sheet.

or you could build a macro that goes through each worksheet
& pulls out the info that has a quantity in it & populate the
summary/proposal page automatically.

i've done the formulas idea before. the macro solution would be,
i think, quite involved with lots of "if's".
susan

 

[Bob Phillips]

Wouldn't it just be formulae of

=Servers!A1
=UPS!A1

etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)