Macro for Excel tabs

[amattey]

Hello,

Can anyone help me with a code that will copy a complete sheet including the macros within it and create another tab within the same workbook and name the sheet with the current month and year? Kinda like when I run that macro it will create a tab with the tab name for example "August, 2011" and will be an exact copy of the original sheet including its macros.

 

[amattey]

Yes, like that. I had something similar but was missing a command. Now my excel document seems to have such a large size. It is 10MB but I only have one sheet with like 3 macros. Is there any way to check why is it so big and fix it?

 

[Ruddles]

I tend not to look at the size of my workbooks too closely unless they have speed or response problems. I'm aware that others have discussed this topic on the forum so I suggest you do a search and see if you can find anything.

You could try this in a copy of your workbook: create a new worksheet, select the part of your original sheet which has the data in it, and copy that to your new sheet, then delete the original sheet. Repeat for as many sheets as you have in the workbook, then save and close the workbook. That might make a difference.

 

[amattey]

I wrote a macro to filter data, but I am stuck on how to keep writing so I can only copy certain columns but just the filtered data. Do you think you can help here? I know I've been asking millions questions but still getting used to the VBA writing.

 

[Ruddles]

I've never really used filters. Try searching the forum to see if there's any useful info and failing that, start a new thread asking for assistance.