Copy Paste using loop from one cell to another cell in a different column

[Ganeshgopinath]

Hi Gurus,

I am trying to copy a cell value from Column D to Column C referencing cell "Orders per day" in Column A. Basically a if statement with a loop (IF Column A = "Order Per Day" then Copy Column D value in Column C this should go on until there are no "Orders Per Day" text in Column A). I tired to record a macro with some limited success, but am not able to figure out how to write a better vba with loop. I have attached a copy of my workbook for your inputs.

Please advise if someone could assist me.

Regards,
Ganesh

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[Ganeshgopinath]

Thank you Sir, the code worked like it is supposed to. However is it possible to modify this action to happen only once every month when there is a change in date. Say current month in Cell D10 changes from March to April.

Your advice would help me greatly.

Once again thank you Jerry.

Best regards,
Ganesh

[JBeaucaire]

Your question doesn't match the original ask nor does it seem to match the sample workbook. Please upload an example that exactly demonstrates the before/after that you are seeking.

[Ganeshgopinath]

Sorry about the inconvenience. I am trying to copy a cell value from Column D16 to Column C16 referencing cell "Orders per day" in Column A. This action should happen only when the month in Cell D10 changes. If the month in cell D10 does not change (I update the file multiple times during the month) then the data in Cell C16 should remain unchanged. Now there are 10 sheets in the workbook, this VBA should only run on 4 sheets . I have included 2 sheets on which the vba needs to run.

I am attaching a workbook with comments on the cells that need to be changed. I hope this example helps you in understanding what I am trying to accomplish. I am a novice when it comes to writing vba.

Thanks

Ganesh

[JBeaucaire]

Hmm, looking at your new sheet, I see three spots you circled in red, but I see no difference in those and the additional spots further down the sheet you did not circle.

I do not see the logic for updating those rows and not the other rows further down.

[Ganeshgopinath]

You got me on that, I circled it only for reference. The sheets need to be updated all through to the end.

[JBeaucaire]

Then I fail to understand how the macro already provided fails to serve. When run on any sheet it will update every row that has Orders per day in column A. Is it not doing that for you?

[Ganeshgopinath]

Hi Jerry, the macros you provided works fine, however I would like the vba to trigger only when the information in (current month) cell D10 changes. Cell D10 represent month and if based of a formula. It is populated using this formula "DATE(YEAR(TODAY()),MONTH(TODAY()),1)".

[ATTACH][/ATTACH]

Hope this information helps.

thanks
ganesh

[Ganeshgopinath]

Jerry, I came up with this macro for triggerring the VBA once date changes (included your part of the vba too), and it looks like it is working as I manually change the D10 cell to test it. Not sure if it is the right, will only know as I test it in the actual report. Please advise if it makes sense from your point of view.

Thanks for helping.

[JBeaucaire]

Glad to be of help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.