Copy & paste between file's

[MoldyBread]

Hello
I am looking for macro that will do the following mentioned below

It will find the data present in H13 in Book2.xls & after finding the same it will copy the entire row of Book3.xlsx (1st Row) & paste that much times of data in Book1.csv & will save all the changes made in csv file and will close all the file

Thanks!

[Logit]

.
This is one method :

Please Login or Register  to view this content.

[MoldyBread]

Hi Logit,
u haven't mentioned about the Book2 in the above macro
Plz check the macro again

[Logit]

.
The macro is pasted in Book2. That is all that is required, as it check Cell H14 on Sheet1, then the macro goes from there.

Perhaps to make it "a little more "correct" ", here is a slightly edited version :

Please Login or Register  to view this content.

Paste the above in Book2, in a regular Module.

[MoldyBread]

Hi Logit,
I tried to somehow edit the macro but i am unable to do so,Macro is pasted(placed) to another file (not in Book1,Book2,Book3)
plz modify the macro again

[MoldyBread]

Atlast I modified the code andit is working perfect
Thanks Alot Logit
Have a Great Day