copying accross multiple worksheets
Posted by Colin on January 04, 2002 7:45 AM
I am trying to insert a new column into a number of worksheets.
They all have the exact same format and I need to insert a new column that deals with information regarding 2002. I would like to know how I could add this column to each worksheet at once without having to do it manually for each.
There is also some graphs in the various worksheets that deal with data in the workshet. The range of these graaphs only goes until 2001 and I need to extend the range to account for the new column for 2002.
I'm stumped and any help is appreciated. Thanks,