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

--
Message posted from http://www.ExcelForum.com