Copy SubAmount

[dzrdw0]

I have this code which works fine but I just couldn't figure it out how can I copy the content of "SubAmount" to the cell on the left of it and the "SubAmount" are randomly on various cells on Column F . any help would be appreciated.
For instance:
the SubAmount on F10 ---> copy to E10
F13----> copy to E13
and so on..

Please Login or Register  to view this content.

[TMS]

SubAmount is a variable defined in the code.

In the loop,

Please Login or Register  to view this content.

determines which row, R+1, and which column, F, are used as the cell reference.

So, if you want to put something in column E on the same row, use:

Please Login or Register  to view this content.

If you want to put the SubAmount value in column E rather than column F, just change the code to:

Please Login or Register  to view this content.

Regards

[dzrdw0]

TMShucks,

You're the best. You just resolved my nightmare. Thanks.

[TMS]

You're welcome. Thanks for the feedback.