Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I look up one worksheet and insert in another?
I have a workbook with 5 worksheets. The first work sheet is with "raw" data
- date, names, and duty, etc. the other 4 sheets are meant to be for each name. How do I set up the workbook/sheet, so that the 4 "name" sheets" reflect the "raw data" only for the individual required. I think that I need to use the vlook up or hlookup function, but am not sure. Any assistance would be of great (massive) help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I look up one worksheet and insert in another?
Hi
Rather than extracting data to separate sheets, why not mark your header row and DataFilterAutofilter Use the dropdown on name to view just the set of data for that individual. If required, you could copy the visible rows to another worksheet. -- Regards Roger Govier "Adi" wrote in message ... I have a workbook with 5 worksheets. The first work sheet is with "raw" data - date, names, and duty, etc. the other 4 sheets are meant to be for each name. How do I set up the workbook/sheet, so that the 4 "name" sheets" reflect the "raw data" only for the individual required. I think that I need to use the vlook up or hlookup function, but am not sure. Any assistance would be of great (massive) help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert A Worksheet using VBA | Excel Discussion (Misc queries) | |||
How do I insert an object onto a protected worksheet? | Excel Discussion (Misc queries) | |||
How to insert line of text on other worksheet depending upon result in a cell? | Excel Discussion (Misc queries) | |||
How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) |