Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing Data Between Worksheets
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing Data Between Worksheets
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. -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=520236 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing Data Between Worksheets
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? -- spartikus ------------------------------------------------------------------------ spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272 View this thread: http://www.excelforum.com/showthread...hreadid=520236 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |