Copy

[Khalil Handal]

Hi,Hope any one can help.I have 2 wokbooks with 15 sheets in each of
them, 12 sheets have the same name in each workbook. I
want the macro to verify the sheet name that it is run
from in the first work book (HCP_2005) and copy
the filtered rows to the second workbook WV_2005 to
the same sheetname, i.e. if the macro is run from the
sheet "January 2005" in workbook "HCP_2005" then the
copying will be done to the workbook "WV_2005" in the
sheet with the same name "January 2005". The 2
workbooks are in the same folder.

Khalil

 

[Ardus Petus]

"Filtered rows" means you've applied an Autofillter to your data?

Cheers,
--
AP
"Khalil Handal" <[email protected]> a écrit dans le message de Hi,Hope any one can help.I have 2 wokbooks with 15 sheets in each of
them, 12 sheets have the same name in each workbook. I
want the macro to verify the sheet name that it is run
from in the first work book (HCP_2005) and copy
the filtered rows to the second workbook WV_2005 to
the same sheetname, i.e. if the macro is run from the
sheet "January 2005" in workbook "HCP_2005" then the
copying will be done to the workbook "WV_2005" in the
sheet with the same name "January 2005". The 2
workbooks are in the same folder.

Khalil

 

[Khalil Handal]

Yes, autofilter is applied to the data?

Khalil
"Filtered rows" means you've applied an Autofillter to your data?

Cheers,
--
AP
"Khalil Handal" <[email protected]> a écrit dans le message de Hi,Hope any one can help.I have 2 wokbooks with 15 sheets in each of
them, 12 sheets have the same name in each workbook. I
want the macro to verify the sheet name that it is run
from in the first work book (HCP_2005) and copy
the filtered rows to the second workbook WV_2005 to
the same sheetname, i.e. if the macro is run from the
sheet "January 2005" in workbook "HCP_2005" then the
copying will be done to the workbook "WV_2005" in the
sheet with the same name "January 2005". The 2
workbooks are in the same folder.

Khalil