Thread: 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.

Hi

Rather than extracting data to separate sheets, why not mark your header
row and
Data>Filter>Autofilter
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" <Adi@discussions.microsoft.com> wrote in message
news:24C3C260-63B6-4BFB-8F27-F87E775A7775@microsoft.com...
>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.