Filter 2 columns onto Sheet 2!!

  • Thread starter Thread starter sparky3883
  • Start date Start date
S

sparky3883

Hi All.

I have a file which contains 2 sheets. Sheet 1 holds all my info an
Sheet 2 holds selected info from Sheet 1.

At the moment, i am using the Data|Filter|AdvanceFilter option to cop
a column from Sheet 1 to Sheet 2.

I was wondering if it is possible to use this feature to copy tw
columns together from sheet 1 to sheet 2.

For example, if i needed to copy infromation from Columns A and D(bot
down to Row 20), how can i go about doing this without having to do th
Data|Filter|Advance Filter option twice?

Is this possible? Would i need to record a macro?

Any help is very much appreciate
 
In sheet2, just put the header for column A in A1 and the header for column
D in B1 and designate those two cells as your destination.

So if sheet1 had the headers

header1 header2 header3 header4 header5

on sheet2 you would put


header1 header4

then run the advanced filter, specifying copy and designating Sheet2!A1:B1
as the destination.
 
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

Code copies twice...? 13
Copy columns and paste with blank column between 5
Auto Copy Data from one worksheet to another 1
Macro to copy value in field and insert it into filter 2
Progressive number in different sheets 7
group filtering 2
VBA comparing sheets and cells 1
another filtering question 1

Back
Top