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


--
Mr Roboto

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


On Feb 7, 9:01 am, someguyinIAreally
wrote:
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

--
Mr Roboto

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)



"someguyinIAreally" wrote in
message ...
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


--
Mr Roboto