Selecting rows from various sheets

  • Thread starter Thread starter shav
  • Start date Start date
S

shav

Thanks for the reply Frank, but unfortunately it's a bit over my head.
Something simpler would be better. I've managed to create a column that
has unique values of all the identifiers. So now all I need to do, is
compare the unique identifier with the other sheets and extract the
data from the other columns on each sheet. Cheers
Shav
 
Hi
what is so difficult with VLOOKUP?. Use something like
=VLOOKUP(A1,'other_sheet'!A1:B100,2,0)
 
You must log in or register to reply here.

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

Filtering of data in a master excel sheet from multiple sheets 3
copy rows from one Data sheet to another sheet based on cell conte 2
Selecting rows from various sheets 1
Get information from one sheet to another 2
Need a macro to combine the data from sheets 3
Need a Macro to combine 1-5 sheets in one sheet 1
Copy formula from various sheets 2
MACRO 2 COPY UNIQUES TO NEW SHEET 5

Back
Top