Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

copy and paste

0

all files are located same place

vba is placed in a sepearte file c.xlsx

copy all the data from column A TO COLUMN H complete data  from a.xlsx and paste it to b.xlsx in same columns

save and close the b.xlsx and a.xlsx  

i need to do the same by vba

Answer
Discuss

Discussion

C'mon, give it a try at least - this is a free forum to help you, not build you things from scratch. Give it a go and paste your efforts back here. There are many simple macros, even here on teachexcel that copy/paste and macros to open other workbooks and copy data from them into another one, just do a search for it.
don (rep: 1989) Feb 28, '20 at 6:50 am
I SEarched but i was unable to find it and i am a beginner so i dont know sir plz help
style36 (rep: 24) Feb 28, '20 at 7:06 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login