[newbie] VBA macro for 'copy and paste'

  • Thread starter Sm9u
  • Start date Views 1,123
Status
Not open for further replies.
S
#1
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?
 
R

Roady [MVP]

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

Good luck!

---
"Jon" <Jon> wrote in message
news:AD5D278E-3244-4154-9E84-A10453EABE7A@microsoft.com...
> 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?


 
Status
Not open for further replies.

Similar threads

Top