Excel VBA - copy filtered value

Question

0.00/5 (No votes)

See more:

Hi,

I have data in cell A2 in each sheet of workbook1 and master data in workbook2
I want macro to copy cell A2 of sheet1 of workbook1 and goto workbook2 and autofilter field 5 with values copied from workbook1. then copy the data except header, go to workbook1 and paste data below last visible cell in columnA. then go to sheet2 copy data from cell A2 and go to workbook2 and autofilter field5 copy and paste in same way, repeat the task till last sheet.

I,m very new to VBA and trying to learn, can you please help me.

every little help is much appreciated.

What I have tried:

i tried writting the codes in parts but I'm not able to paste values in filter which is coped from cell A of sheet1 of workbook1.

codes are

Sub Copy_Data()
Worksheets(ActiveSheet.Index + 2).Select
Range("A2").Copy

Workbooks("Current_Month_Data.xlsx").Sheets("Sheet1").Activate


End Sub

Posted 14-Oct-18 23:42pm

Member 14011636

Updated 15-Oct-18 1:01am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2018-10-14T23:48:00

Solution 1

One of the best ways to learn how to do tasks like this is to use the macro record feature of Excel. Start the macro recorder, execute the steps you want, stop the macro recorder. You can now edit the recorded code and modify it as necessary for your own requirements.

Posted 14-Oct-18 23:48pm

Richard MacCutchan

Maciej Los · Answer 2 · 2018-10-15T01:01:00

Solution 2

Take a look at this tip: Copy Data Between Excel Sheets using VBA[^]. Use solution #2 and change to your needs.

Posted 15-Oct-18 1:01am

Maciej Los