merge 2 cells and change format
If you want a macro then start recording and follow these steps.
In C1 enter the following formula
=A1+B1/100
Copy down to bottom of list.
Copy column C and right click on A1 and select "Paste Special" select values
and ok.
Delete columns B and C
Stop recording
you now have a macro that will do this automatically.
TIP to start recording a macro select Tools-Macro-Record new Macro
to stop recording select Tools-Macro-Stop Recording
"fifi" wrote:
Ya i know its real simple to do that way but its for a report so they
want to be able to click a button n hey presto...it does the job for
them
i get the other ways and thanks for that
Gloria Thrurk wrote:
Fifi !!!!!!!!!!!!!!!!!!!
Stop talking about macros.
Macros have nothing to do with it.
You just want to copy a formula from one cell to another.
You can do it with the mouse as Max suggests.
Or with the keyboard as I suggest.
You need to get more familiar with the basics before getting on to macros.
You're trying to do the triple-salto before the cartwheel.
Gloria.
|