Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using one worksheet to pull data from many
Hi, I would like to set up a costing worksheet to pull many bits of data from
every other worksheet in the book. Each worksheet is it's own seperate po and it's set up in a printable format I guess. I would like to pull data from all over the form i.e. P.O. #,Issue Date,UoM, etc. Is there a formula that can do this or is it a manual thing because of the way the data is distributed all over the place? Below is part of the template I use. I don't know if this will make sense to anyone but it's worth a shot. Thanks, Sara Purchase Order ORDER NO. (D4&E4) RELEASE NO. Issue Date Date Recieved (merged cell H5-J5) ORDER FROM: Operating Center : ATTENTION: Supervisor : TEL: Purchaser: Item Quantity Unit of Measure Description Unit Price Extended Price Code # (A28) (B28) (C28)etc. $- $- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using one worksheet to pull data from many
Sara
If you want to place data into a specific cell in the cost WS, and pull that data from a specific cell in a specific sheet, and those 3 parameters (cell, cell, sheet) never change, then a formula in the cell in the costing sheet is the way to go. There are some exceptions to this, like if you want to pull data from a table of data for instance, or if the source cell location is dependent on some condition that can be defined. In those cases, a formula would work as well. As you guessed, what you wrote doesn't make much sense to anyone but you. Post back and give some specific details about what you want. For instance: In this cell I want the entry from that cell in that sheet. Repeat this for a dozen or so cells. If the cells are not always specific, provide an explanation of how to determine what cell you want. This will give us an idea of what you are working with. HTH Otto "Sara P." wrote in message ... Hi, I would like to set up a costing worksheet to pull many bits of data from every other worksheet in the book. Each worksheet is it's own seperate po and it's set up in a printable format I guess. I would like to pull data from all over the form i.e. P.O. #,Issue Date,UoM, etc. Is there a formula that can do this or is it a manual thing because of the way the data is distributed all over the place? Below is part of the template I use. I don't know if this will make sense to anyone but it's worth a shot. Thanks, Sara Purchase Order ORDER NO. (D4&E4) RELEASE NO. Issue Date Date Recieved (merged cell H5-J5) ORDER FROM: Operating Center : ATTENTION: Supervisor : TEL: Purchaser: Item Quantity Unit of Measure Description Unit Price Extended Price Code # (A28) (B28) (C28)etc. $- $- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull parameter from worksheet for External Data Query to SQL Datab | Excel Discussion (Misc queries) | |||
Pull a value from another worksheet | Excel Worksheet Functions | |||
Pull list / dropdown data from another worksheet? | Excel Discussion (Misc queries) | |||
How do I pull data from a previous worksheet? | Excel Worksheet Functions | |||
Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions |