Copying Data

Mark Wilson
Mark Wilson used Ask the Experts™
on
Hi

I using Excel 2010

I have tabs on one spreadsheet - Main, O and B.

In the Main Tab I have the following data (example data)

Matter        Sort              Date
1                  B                  21/10/2011
2                  O                  21/10/2014
3                  B                  20/10/2013

I want to make sure that anything with Sort O - copies that row of data into Tab O (this case would be 1 row)
and anything with Sort B  copies that row of data into Tab B (in the example 2 rows).

The Main tab data gets populated on a daily basis with new data

Any help would be appreciated
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rob HensonFinance Analyst

Commented:
You can use the Advanced Filter function to copy filtered data to another location.

If doing it manually rather than through VBA, the destination sheet has to be active and the cursor in a blank area when initiating the AF function.

Source sheet has to have unique headers for all columns of data.

Destination sheets have to have the same headers as source sheet but don't have to in same order or even all of them, so long as those that are used are the same as the source.

If using VBA, I would suggest the steps would be:

1) Clear Destination sheets, except headers
2) Run Filter for B with sheet B as destination
3) Run Filter for O with sheet O as destination

Thanks
Rob H

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial