vba Copy Paste Conditional to put remark 1 2 3 .. etc

[fixer]

All files are located in different path
sheet name can be anything
I have a file ap.xls & Book1.xlsm
macro will be placed in Book1.xlsm
We have to look on Column S of ap.xls and If column S of ap.xls has negative numbers then we have to look on Column E of ap.xls & we will match that Column E data of ap.xls with column A of sheet1 of Book1.xlsm & if it matches then we will see wheather column C of Book1.xlsm has data in it or not & if column C of Book1.xlsm has data in it then do nothing & if column C of Book1.xlsm doesn't have data then we will go to sheet3 of Book1.xlsm and we will look for a match of Column E data of ap.xls with column A of sheet3 of Book1.xlsm & if it is found then we will copy the data from sheet3 of Book1.xlsm and paste it to sheet1 of book1.xlsm & we increase one more number in series in it

Sheet4 is the output that i need in Sheet1 (Result is pasted in sheet4 only for understanding purpose, i need result in sheet1 only)



plz see the sample file

[Molly Brennholz]

Hello Avinash.
Good to see you back!

I have written a macro for you here: https://excelfox.com/forum/showthrea...ll=1#post13417

---

I have written 'comments to explain the macro
We all understand that you do not want to learn any VBA. But it is madness to not attempt to understand anything of the coding which we give you.
I assume you will want to use these codings later for something important to you?
If this is the case, then you will fail, because we will not be with you later every step of the adventure.
You must make at least some attempt to understand the coding.

But its your choice.

Molly

---

Macro is also in Book1.xlsm
Share 'Book1.xlsm' : https://app.box.com/s/qotw65wmiq1aln7frg9o5gys8ke1l8xh
Share 'ap.xls' : https://app.box.com/s/r0tc0hkwoxrqjsqfu4gh7eqyy5jmqlg2

[fixer]

Thnx Alot Molly Mam For giving ur Great Support & helping me in solving this problem Mam

We all understand that you do not want to learn any VBA. But it is madness to not attempt to understand anything of the coding which we give you. (Thnx for understanding Me, But I Was Busy in making of Something & Now i am very near to get free time to do some work & then i will play with vba )


we will not be with you later every step of the adventure.(That Day will be the worst day of mine But i will some how manage it & i don't want that day should come)



Problem Solved