VBA Excel Macro to add worksheets

Richard Swearingen — Wed, 08 Oct 2003 21:19:13 GMT

Hi...Im have a time sheet at work and a worksheet tab for each week of the year, each named, for example 02-03-04, for each week. Each worksheet tab has our time sheet on it. There are times we need to update the timesheet and I need a way to have VBA copy the changes I made on the master timesheet to each 52 tabs. I started writing an array and also a "For each" statement but I got hung up.
example....
I make changes to cells A1:C10 on the master, now I need to have VBA macro take those changes in those particular cells and copy it to every worksheet tab not equal to "Master"
Thank you for your help

Re: VBA Excel Macro to add worksheets

Ganesh Babu — Fri, 31 Oct 2003 16:48:34 GMT

if u can show me the code what u have written.. i can help u..

If not try this instead of macro, your requirement is to copy the data from master to all the 52 sheets right??.. so as a initial setup, give the reference to the cells in the 52 tabs to the cell of Master. this way u will be able to achieve the same stuffs..

Hope this help..

Ganesh

topic VBA Excel Macro to add worksheets in Operating System - Microsoft

VBA Excel Macro to add worksheets

Re: VBA Excel Macro to add worksheets