I am trying to make a macro that will take information i highlight, then make a new worksheet and copy the information there and name the worksheet based on information in cell A1 i need it to be able to do this about 180 times. if some one can show me how to do this i would greatly apreaciate it very much!
(its excel 2003 if that matters)
updated in my reply!
Ok on the 1st page for the charts i have a highlighted area, and on the page titled sheet 1 is where i want the data to go if i had highlighted an area and hit a command i want it to open a page like on sheet one and then name the page based on c-4's content
Bookmarks