View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
he4giv he4giv is offline
external usenet poster
 
Posts: 14
Default copy data to each worksheet

Hello:
I wrote a macro to copy one worksheet for each week of the year and name
each tab to each weeks date using Dataserial and it works fine. Now what I
need to do when some areas change on the worksheet is to be able to change it
on one and have the macro copy the changes to each worksheet. For example on
the timesheet when billing codes change that may be in range B2:B12 is to
have the macro copy that range onto each worksheet. please help.
--
He4Giv (Dick)