Vba Code to extract data and copy to another worksheet

[zelda13]

Hello Everyone,

Need a vba code to extract data from worksheet name "Data" and copy to worksheet name "Report" , base on the value of "M1".
See desired output in worksheet name "Desired Output".


.::Thanks in advance::..

[MikeVol]

Hello @zelda13 . You can do this using AutoFilter. Try this code:

Please Login or Register  to view this content.

Good Luck.

[zelda13]

Hi @Mike

Thank you and appreciate your help.
May I ask you to adjust your provided code.
It appears that the data extracted overwrite the Header in Report Worksheet.


Thanks

Regards
zelda13

[MikeVol]

No, you are wrong that the extracted data overwrites the header in the Report Worksheet. Unless, of course, your header is on both Worksheet in the first line. This line is responsible for copying from the Data Worksheet:

Please Login or Register  to view this content.

, it takes the range starting from the second row after the header.
And this line is responsible for inserting data onto the Report Worksheet:

Please Login or Register  to view this content.

, accordingly inserts data into the Report Worksheet starting from cell A2, second row.

[jindon]

Simply,

Please Login or Register  to view this content.

[windknife]

If you have O365, you can do it by formula.

Report!A2

Please Login or Register  to view this content.

[zelda13]

[QUOTE=, accordingly inserts data into the Report Worksheet starting from cell A2, second row.[/QUOTE]

@Mike

Got it... Thank you!

I appreciate your taking the time to write a reference for me.

Regards
zelda13

[zelda13]

@windknife
Thank you for providing a formula but I need a vba code.

@jindon
Thank you for providing the alternate code.

[MikeVol]

@zelda13. You're welcome and thanks for rep+
Sorry for my English. Good luck.

[zelda13]

Guys,

Please do me a favor...I forgot to mention that column A & G are excluded in my report.
Could you please rewrite the code that you have provided, if possible. Thanks

Sorry for the inconvenience.

[jindon]

Like this

Please Login or Register  to view this content.

[MikeVol]

Untested!
Change this line in my code:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

[zelda13]

@Mike @jindon

Thank you so much for the help.

Regards
zelda13