| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining two reports into one
Report 1
Prod a 7 am - 10 am Prod b 10 am - 11 am Prod a 11 am - 3 pm Report 2 Prod a, type 1 Prod a, type 2 Prod a, type 3 Prod b, type 1 Prod a, type 1 Report 3 (combines hours, delay, and wet waste from report 1 and the specifics of report 2) Prod a, type 1, 7 am - 10 am Prod a, type 2 Prod a, type 3 Prod b, type 1, 10 am - 11 am Prod a, type 1, 11 am - 3 pm Is there a way to look up the information about Prod a from Report 1 and transfer it to Report 3. Right now I'm combining the same products and using a vlookup formula because the information changes daily but many of the applications that my employer uses keeps this information separate. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count reports per month | Excel Worksheet Functions | |||
| How can I make reports faster in excel using ADO | Excel Discussion (Misc queries) | |||
| How to create org chart from excel file with reports to column | Charts and Charting in Excel | |||
| merging reports | Excel Discussion (Misc queries) | |||
| Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) | |||
Hybrid Mode
