Sharing Data Between Worksheets

[spartikus]

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?

[CBrausa]

Check your cell range. In your formula if your range is A1:Z196 but your information is in row 197 it won't pick it up.

[spartikus]

I understand that, however, I want it update cells if I add them because when doing a bid I am always adding or deleting products from it and I want the other worksheet to update. I am guessing what I need to do is some kind of Visual Basic Programing to accomplish this but I would like to find a way so that I don't have to. Any other suggestions?