copy rows from multiple worksheets

  • Thread starter Thread starter paul mueller
  • Start date Start date
P

paul mueller

I need to get a list from each worksheets "B"column, then fill a listbox
with unique items from that list, when an item is selected, to match it to
all matching items within column "B" on each sheet and copy the row that the
matching item is on to Sheet1.


I am at a loss as to how to get matching rows(listbox value) from each sheet
( sheet2 to the end sheet) to copy to sheet1.


Thanks
Paul
 
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

My Never ending ARRAY code problems 18
Create if partial match then copy and paste data from one cell to another 1
loop to copy paste 5
Sheet to sheet code Type Mismatch 6
Need some help constructing a Do While statement 2
copy from multiple sheets 2
Resize to last entry in row and copy to sheet 1 3
Compating all rows in two sheets 2

Back
Top