Looping Copy/Paste Macro

[yuuuh]

Hi all,

I'd like to create a macro that copies one cell of a range, pastes that cell on another sheet, then clears the cell pasted into. Takes the next cell in the range, and then copies it into that same cell previously used.

For example this would be the operation, I'm just not sure how I could get it to loop.

Please Login or Register  to view this content.

Thanks for any help!

[jaslake]

Hi yuuuh

I'd like to create a macro that copies one cell of a range, pastes that cell on another sheet, then clears the cell pasted into. Takes the next cell in the range, and then copies it into that same cell previously used.

OK, I'll bite. You're copying a cell, pasting, deleting the paste, copying a cell, pasting, deleting the paste, etc, etc, etc.. Correct?
Why? What's the purpose? It'll help if I know your end goal.
John

[yuuuh]

Exactly. The cell being pasted into is referenced in an equation, so when the new paste occurs, a value changes. I would like to be able to control when the next copy occurs via a key, so that the value can be observed. Not sure if that makes sense, basically to see the impacts of user defined values on an equation.

[jaslake]

Hi yuuuh
OK, that makes some sense. I think I can help you with this. However, if you could post some sample data with the results, it'll help me see if things are calculating correctly. Not a "must" just may save some aggravation
John

[yuuuh]

For sure, here's a simple sample.

[jaslake]

Hi yuuuh
Try this code

Please Login or Register  to view this content.

Let me know of issues
John

[teylyn]

yuuuh, please don't quote whole posts. It's just clutter.

[Leith Ross]

Hello yuuuh,

You should read about Scenarios in Excel. Scenarios allow you to select specific cells to be changed and observe the results on the remaining data.