Solved: Excel - Resetting Tabs All at Once - Page 2

MCBride · 09-Oct-2008, 02:50 AM **#16**

[COLOR="Purple"]I want a workbook with 30 tabs. Each tab would be a day of the month. Example September 1 - September 30. Each tab would contain a transmittal with daily transactions. I want to copy and paste into a new workbook and change the bottom tabs to October[ instead of September. Can I do something similiar to a replace all?/COLOR]

slurpee55 · 09-Oct-2008, 04:41 AM **#17**

Here are a couple of macros that will rename the worksheets based on the data that is in a column of another worksheet - you could just make all the dates you want in that sheet and then make sure the right month's were in the correct column each time
http://it.toolbox.com/wiki/index.php...Worksheet_Tabs
http://www.mrexcel.com/archive/General/15953.html

MCBride · 10-Oct-2008, 11:32 AM **#18**

Thanks. This works.

slurpee55 · 10-Oct-2008, 11:56 AM **#19**

Cool. Glad to assist.

Tag Cloud
access acer asus bios bsod computer crash drive driver drivers error ethernet excel freeze games gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard netgear network printer problem ram random registry router slow software sound trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!