Filter and copy info from one sheet to another

I

ian-ok

Hi

I'm trying to copy rows of information from one worksheet to another dependin
on a criteria of a certain cell.

For e.g.
worksheet 1 has a rows of data from A2 to AM2 being one full set of data and s
on

In Column b2 i have the property address and want to filter all the fields wit
the same property address and make the list appear on worksheet 2 in the sam
format as worksheet1 i.e.a2 - am2

Is this possible?

Thanks Ian
 

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

How to copy files from Onedrive account to another 2
If, VLookup, Index, or a combination of all of them? 7
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Copy and paste slide from one presentation to another presentation gives an error 2
VBA Coding Help for Beginner 0
how to copy and paste value from one sheet to another 4
Displaying Returns from another worksheet that change? 3
need help on either doing a loop and counting specific values orusing subtotal function 2

Top