Find your solution!

MCBride · 09-Oct-2008, 01: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, 03: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, 10:32 AM **#18**

Thanks. This works.

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

Cool. Glad to assist.

Tag Cloud
access audio blue screen boot bsod connection crash dell desktop driver dvd email error excel excel 2003 firefox hard drive hardware hijackthis internet keyboard laptop malware monitor motherboard network networking outlook problem processor ram recovery router screen slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless

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

Search
Search for: