[newbie] VBA macro for 'copy and paste'

[Jon]

I have an excel sheet which needs to copy values iteratively.

So for example, on sheet 2 I want to

1. copy value of sheet 1 > cell A1 to sheet 2 > cell A1
2. print it or send it to a print queue
3. clear the values from sheet 2 > cell A1
4. copy value of sheet 1 > cell A2 to sheet 2 > cell A1 (replace contents)

The above process would be repeated for a number of values that is displayed
within sheet 1 > cell A1.

Any ideas how to go about it?

 

[Roady [MVP]]

Wrong newsgroup?
This one is for Outlook. Excel has its own set of newsgroups.

Good luck!