Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve Data from one sheet to another
I have data on one sheet with some of the following columns Workorder ~ Date ~ Description ~ Quantity ~ Amount ~ G/L Account NU-702-06 ~ 6/6/06 ~ Menards ~ 0 ~ $150.00 ~ 2232 Then I have 100+ tabs for each workorder. Each tab contains a form that has information on it regarding the invoices that pertain to that workorder. What I would like to do, is enter all the invoices on that first sheet and have each tab automatically update. So for instance, in the example above, I would like to have that same information show up on the form for tab 702. Does that make sense? Currently I have the first sheet show all the invoices and then I copy and paste each one into the individual workorder sheets. I am sure there is a better way to do this, I just can't seem to figure it out. Thank you for your help in advance! -- karstens ------------------------------------------------------------------------ karstens's Profile: http://www.excelforum.com/member.php...o&userid=17657 View this thread: http://www.excelforum.com/showthread...hreadid=560435 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |