first sheet column "E" value copy to second sheet column "I"

[johncena]

what this macro doing is ,after enter values to second sheet column "F" it's matching with first sheet("order history") column "M" & picking data to second sheet.

Please Login or Register  to view this content.

at the moment this macro coping first sheet column D,H,F,G,I,C values to second sheet A,B,C,D,E,H.

my requirement is same like others,first sheet column "E" value need to copy to second sheet column "I" ,if first sheet column "E" is empty then same row column "H" value i want to copy to column "I".pls add this modification to this macro.thanks in advance.

[Kelshaer]

Try this:

Please Login or Register  to view this content.

[johncena]

Kelshaer@ thanks a lot for your code.column"E" it's coping correctly & column "H" it's not coping.i have attached sample sheet here.pls check it.thanks in advance..

[Kelshaer]

Try this

Please Login or Register  to view this content.

[johncena]

Kelshaer@ thanks a million it's work very well.REP+
I have small problem with below code.can u pls edit your macro to run with any sheet.because i have to run this code with 3 sheet.
Set osh = ThisWorkbook.Worksheets("Day")

[Kelshaer]

Ok Let me see it

[Kelshaer]

Here you Go. It will work with the active sheet

Please Login or Register  to view this content.

[johncena]

I have checked but not work.pls check this..

[Kelshaer]

I cant figure out where in you summary code do you call the Movedata sub!
Anyway, Try this one and let me know

Please Login or Register  to view this content.

[johncena]

thanks a lot friend.it's work.my problem is if i add new sheet this code not work.i don't have a VB knowledge & pls tell me the reasons.

[Kelshaer]

Try this:

Please Login or Register  to view this content.

[johncena]

Kelshaer@ thanks a lot friend.now everything ok.thanks a lot again.. :D