copy specific cells from sheet to another with calculation

[tubrak]

hello
I have specific data in specific cells in sheet1 & 2. I want copy cells G4 to COL B and F3:F5 to COL C and G7 to COL D and G8 to COL E and I9 to COL F OR G based on word in F3 if f3 = unpaid then should copy I9 to COL F and if F3= paid then copy to COL G and calculate the balance in COL H
I put two cases to show the result how should be in sheet3

[nankw83]

Hi tubrak,

Try below code ...

Please Login or Register  to view this content.

[tubrak]

thanks
but it just copies from sheet1 . it ignores sheet2

[nankw83]

I though that was illustration only ... I don't know how you'll be running the macro but if you're going to place a button in each sheet, you can utilize the same macro (chaning one line only) as per the attached file

Please Login or Register  to view this content.

[Sintek]

Please Login or Register  to view this content.

[tubrak]

thanks, but there is no way to make one line by make two sheets in array instead of move from sheet to another and make it active.

[tubrak]

@sintek wow! exactly this what I want . if it's possible can I add the formula by your code and show as value not formula ,please?
thanks again

[Sintek]

Here you go...

[tubrak]

@sintek brillaint ! that what I'm looking for
thanks vey much

[Sintek]

Glad I could help...Tx for rep +