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" <(E-Mail Removed)> wrote in message
news:24C3C260-63B6-4BFB-8F27-(E-Mail Removed)...
>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.