hi all,
just came across this forum and joined today.... however when i post the question the thread doesn't get posted so here it goes
i have a small macro which creates worksheets based on a list on a separate sheet, e.g., first sample, second sample, so forth and so on. however, i have on another sheet vlookups searching for certain info on these sheets... i'd like to have a macro rename all those sheets from month to month so that the vlookups follow the now renamed sheets.
Bookmarks