Copy filtered rows in one worksheet and paste to other worksheet

[tsiddiq23]

Friends,
Totally new to the Excel VBA or Macros. Was just doing first Macro where I want to filter rows in one worksheet and copy them to other worksheet but macro copies all the row to other work sheet. Please see below and guide. Thanks for your help.

Please Login or Register  to view this content.

[HaHoBe]

Hi, tsiddiq23,

welcome to ExcelForum. You maybe need to reduce the raneg to only the visible rows. While being in Excel, choose the range via Mouse, hit F5, press the left button (I only have a local german version, should read either Contents or options), choose visible cells from there, the press CTRL+Copy.

Using VBA you can use SpecialCells(xlCellTypeVisible) for reducing the range:

Please Login or Register  to view this content.

If there aren´t any formulas in the data you could use the destination directly after the Copy like

Please Login or Register  to view this content.

Could you please put code tags around the macro you´re showing? Thanks in advance.

Ciao,
Holger

[Alf]

You could try to replace these lines in your macro:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

If you wish to include the headings from the autofilter settings use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Alf

Ps When you post code you should wrap it (forum rule)

[tsiddiq23]

Hi Ciao,
Thank you for your reply. I do not know how to use the modification you wrote above. See below is complete code that came out when I recorded the macro. I am filtering two columns (separately) in Active Sheet and past (one by one) the filtered rows in "Filter BL Date" worksheet next to Active sheet. I want the rows I get after filtering to be pasted to in "Filter BL Date" worksheet. Sorry, I am totally new to the macros so do not know much about VBA yet. Thanks again for your help.

Please Login or Register  to view this content.

[tsiddiq23]

Hi Alf,
Thanks for your reply. When I replaced the code with yours, it gave me Run_time error"1004". Method 'Range of object'_Global' failed. I think I am not understanding/using it properly. Will try again.
Regards,

Tahir

[HSV]

Put the date in Cell R1.

Please Login or Register  to view this content.

[tsiddiq23]

Hi Harry,
Thanks for your reply. My Active sheet where my data resides (I call it 'Main' sheet) has row 1 as Fields and other rows contain data. 9th and 10th columns are date columns where I filter dates as required. You suggested to put date in cell R1. but R1 is one of the Fields heading. So, how it will work? Thanks again.

Regards,
Tahir

[HSV]

There are a lot cells in Excel, choose one.