(VBA) Trying to transfer filtered data to other worksheet starting from second row

**jackfood** · 05-26-2020, 04:55 AM

I am trying to use VBA to transfer filtered result from sheet 1. Beased on the result filtered, copy them into sheet 2 - the first row which is empty.

Please Login or Register  to view this content.

i am stuck at these set of code which i have no idea how to fix it.

Please Login or Register  to view this content.

encountered error 1004 for debug

**Eastw00d** · 05-27-2020, 12:14 AM

Hi, What if you change your code into this:

Please Login or Register  to view this content.

Cheers
Erwin

(VBA) Trying to transfer filtered data to other worksheet starting from second row

LinkBack

Thread Tools

Rate This Thread

Display

(VBA) Trying to transfer filtered data to other worksheet starting from second row

Re: (VBA) Trying to transfer filtered data to other worksheet starting from second row

Thread Information

Users Browsing this Thread

Similar Threads

Transfer Data from Worksheet A to Worksheet B w/o losing data from Worksheet A whendeleted

Code to copy and paste a data set into a different worksheet starting last row

transfer data to another worksheet, save new worksheet to another folder, all closed

[SOLVED] Transfer Userform data on 1 worksheet to different worksheet (empty row = wrong sheet)

Need Help Creating A Macros To Transfer Data From Worksheet to Worksheet

[SOLVED] Use a button to transfer filtered data to destination cell

[SOLVED] Extract a list from data in sheet1 to sheet2 filtered by a starting date and ending date?

Bookmarks

Bookmarks

Posting Permissions