C&P data from 1 WB to another WB without actually seeing the opening of the pasted WB.

[countryfan_nt]

Hello friends, Hope all is well!

I have a folder called: MD; in it, there are two workbooks:

MDDB and NY.

Can you please help me? I am hoping to have a vba code, in the workbook MDDB module that will:

1. Go to sheet DB in MDDB, and filter column D, the filter will be made on the word NY (i.e. show the data related to NY only).
2. Then copy all the data in DB from A to R, without the headers.
3. and Paste the copied rows (without the headers) onto DB of the workbook NY after the last filled row (A to R).
4. without letting the workbook NY open. At least without letting it look visible please.

I tried doing all the above, and I did successed but in a long and untidy way.
If someone would kindly help me; I will surely learn from that experience, and
Will be able to do it on my own, and will pass on the knowledge for sure.

Thank you so much for the continuous phenomenal help in advance!

[FDibbins]

Have you considered doing this with formulas, instead?

[countryfan_nt]

I would rather if you please to use a code please; since I am dealing with the data for multiple cities. Your kind help is needed and truly appreciated.

[bakerman2]

How about this ?

Please Login or Register  to view this content.

[countryfan_nt]

very very Very Cool! thank you; one little challenge, the code runs smoothly but the NY workbook popups for a second, can the code run without allowing NY workbook visible? But, seriously thank you!

[bakerman2]

First of all thanks for rep+.

I guess that has to do with your system because when I run the code I only see a minor,minor glitch in the cells (have to look very close to mention it).
So I think there's nothing more to be done apart from setting the Screenupdating.