Sharing Data Between Worksheets

  • Thread starter Thread starter spartikus
  • Start date Start date
S

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?
 
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.
 
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?
 
Back
Top