How do I look up one worksheet and insert in another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to show original comment in cell when using Vlookup in Excel? 3
Lookup in multple worksheets 5
Standard Deviation from one sheet to another 1
Use Formula from another worksheet 3
How do I copy the page set up from one worksheet to another? 2
worksheet name variable external data cell 2
How do I lookup the sheetname in a workbook 2

Back
Top