Regarding excel macro's

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I am just trying with Excel Macros, I need particular column data as to filtered automatically and filtered data as to cut from that sheet and move to another sheet in the same workbook,
I will explain with an example,

In Excel having D Column data, D column data as to sorted or filtered with Text like GA or different text-based data and this text-based data should be moved to sheet1 to sheet2. If column D data as to filtered first and based on text this data as to be copied or cut and move to sheet2. I need Column data with row data also.

Please anyone having an idea for above-mentioned problem, share me

Thank you,

What I have tried:

I am just tired with Excel Macros, I need particular column data as to filtered automatically and filtered data as to cut from that sheet and move to another sheet in the same workbook,

Posted 11-Mar-19 20:49pm

Member 12013275

Updated 11-Mar-19 22:35pm

v2

Add a Solution

1 solution

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 · 2019-03-11T22:35:00

Solution 1

You can figure out the basics by using the Macro Record feature in Excel. Start recording, perform all the steps you want, stop recording. You can then edit the captured macro and adjust as necessary. You can also find lots of websites that specialise in the subject.

Posted 11-Mar-19 22:35pm

Richard MacCutchan