I've got 2 worksheets in the workbook. Worksheet A has a chart, based on the
data in w/s B. Worksheet B can be filtered by values in the 10th column
(let's say, values AAA, BBB, and CCC).

I need to write a macro, where the user can select one of the filtering
values (for example BBB) and the macro would filter worksheet B by BBB
criteria, copy all filtered rows in worksheet B and whole worksheet A, create
a new workbook and paste w/s A and selection of w/s B into it.

How do I write a macro for it ? Thanks!

the code at this site should get you started:

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"fbagirov" wrote:

I've got 2 worksheets in the workbook. Worksheet A has a chart, based on the
data in w/s B. Worksheet B can be filtered by values in the 10th column
(let's say, values AAA, BBB, and CCC).

I need to write a macro, where the user can select one of the filtering
values (for example BBB) and the macro would filter worksheet B by BBB
criteria, copy all filtered rows in worksheet B and whole worksheet A, create
a new workbook and paste w/s A and selection of w/s B into it.

How do I write a macro for it ? Thanks!