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)
|