Automatically updating sheet list in excel
Is there a way that after it names the Sheet it can add Data from the List to the New Worksheet? TIA Ramakrishna Helo, I was wondering if it is possible to add a "hyperconnection" (klickable link) between the name in the list and the worksheet whit the same name?
I don't know the code (Thats why I'm asking, haha) but something around the below? So that when you crate a new worksheet it also adds a connection between the list and the new worksheet. I tried this and since my summary tab had 300 records, there were 300 sheets created.
Range("A10") Set My Range = Range(My Range, My Range. Also, is there a way to add these sheet names to existing sheets with data and formulas already preset??? Range("A10") Set My Range = Range(My Range, My Range. Value 'Renames the new worksheets Next My Cell End Sub Hi subop and Ivan, Excellent solutions!
Value ' renames the new worksheet Next My Cell End Subplease let me know where exactly script shouldbe done becus I am not familiar with macros but I would like to create sheet name for about a year datewise from the month of NOV 2009 in a single work book or atleast for a period of 3 months pls reply immdtly thanks I see this is old but need help on a similar topic.
Click "OK." Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine.
The problem I am having is that the new data doesn't update automatically.
The workbook has 6 sheets ("master", "AP", "All AP", "CSW", "CO", and "PSR"). Once you have your workbook set up with the code below, any changes you make on the "master" sheet will raise the worksheet_change event, causing all of the destination sheets in the workbook to get updated with the most current data.