how do i auto filter with value in a cell

E

Eddy Stan

hi

Please guide me

I have dynamic cell range in 3 cells c1, d1 & e1

Now i want autofilter the range below from a5:x5000 with c1 filter in
c5:c5000, d1 filter in d5:d5000 and with e1 in e5:e5000, then copy the
filtered range (which is named copyrange) to a new workbook and save as file
name found in f1 cell

e1 cell has 40 in itself as pull down menu, if the copy goes automatically
till 1 to 40, creating 40 workbooks that will be the best thing i require.

any help on this.
 

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

Using cell row # in a VB macro 2
Copy cell of one excel sheet to other 2
Filter and copy data to other sheet 3
Sum - Sum <> Zero ??? How is it? Bug in Excel formula? 7
Macro to copy value in field and insert it into filter 2
copy cell formula and adjust column spacing 1
How to copy the function SUM but offseted in 7 columns 2
Copy and paste from WB to another WB 1

Top