copy trimed(cleaned) data to four different workbooks in same folder.

I have four excel workbooks (i.e. workbook A,B,C,D )in same folder(name of folder 'data') having path c:\data.All four workbooks have sheets named 'nb' and 'ag' common.
I have raw data in workbook 'A' having two sheets 'nb' & 'ag' I cleaned(trim) data of two sheets in workbook 'A' using trim formula.

I want vba code to copy trimed(cleaned) data to all three workbooks i.e. copy data in sheet 'ag' in workbook 'A' to sheet 'ag'
in work book B,C & D and copy data in sheet 'nb in workbook 'A' to sheet 'nb' in work book B,C & D.

Please Login or Register  to view this content.

Excellent ! Code is giving desired results. Only two modifications required.
01. I want to insert this code in workbook 'A'. When I insert and run code from workbook 'A' error message 'workbook
'A' is open" is displayed and code stops working.

02.When code inserts data in workbook (workbook B,C,D) formulas in that workbook starts calculations and takes lot of time to complete calculations. I want code to turn off 'auto calculating' Mode(switch to Manual calculating Mode) while importing
data and after workbooks are saved turn on 'auto calculating' Mode.

I don't do requirements. do you want to give it a try yourself? you have plenty to learn from now. why not try it? if you get stuck, you can always ask for assistance.

Instead of Activating and Selecting as in

Please Login or Register  to view this content.

would it not be better to use something like this?

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.