I am trying to create a spreadsheet for doing bids at my job. On one
worksheet I view things like quantity, description, and product cost as
well as the sale price, etc. On another worksheet I have created an
invoice for the customer. What I want is for the data on the first
worksheet to link and auto update the information and bascially build
the invoice with the data enter on the first worksheet.

I know how to link cells from one worksheet to the next and it will
update for me if I have all the cells formatted the same but if I
insert a new row to add a product it doesn't update to the second
worksheet. Could someone give me some good advice on how best to build
this spreadsheet?


--
spartikus
------------------------------------------------------------------------
spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272
View this thread: http://www.excelforum.com/showthread...hreadid=520236