View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OdAwG OdAwG is offline
external usenet poster
 
Posts: 35
Default Macro to copy a sheet and name it

Hello All,

In my sheet named MASTER, I have a value stored in cell A15, a numeric value
of 10.
Depending on this value, i would like to make a copy of another sheet
called Bank, 10 times
and name each sheet Bank1, Bank2, Bank3, etc... Bank10.

This value, in cell A15, in sheet Master, can change manually periodically
(daily, weekly, monthly, and etc...)

is this possible to do with a macro?

Any and all help in this matter is greatly appreciated.

Argus