Geez, Chuck. ......Uhhh.... WOW!..

Thank you.

I am sitting here..buzzin...

So The intial steps are?


Really, Thanks Chuck.,... I have to study hard now. My spreadsheet, along
with the help of MVP's is incredibles...


Mark

........... It was hard enough just figureing ou the question. No wonder you
guys are "out of this world".

Intial steps to make the hot key for this step a???

"CLR" wrote:

Doing Tools Macro Record new macro......and then following the steps of
manually inserting a new column to the left of column M and then Copy
Pastespecial Values L4:L100 over to the new M4:M100. During the setup of
recording the macro the pop-up gives you the opportunity to assign your new
macro to a Ctrl-letter, which would in effect become your hot-key to fire the
macro on demand.

Vaya con Dios,
Chuck, CABGx3



"Mark" wrote:

eI need to use the Numbers presntly in L column.
Since there is a formula in L, I need to copy PASTE SPECIAL VALUE L4:L100
to M4:100.

Is there a way to "automatically insert a column left of M, and copy PASTE
SPECIAL VALUE L4:L100 to M4:100."

Could this be a Hotkey?
I do not see how code could do it, unless it refers to a hot key.

Thanks,
Mark