Hi there! I'm trying to write a macro to do the following:
I need to save the first 10 tabs (of 20) in an excel workbook as their own individual reports. The new files need to be saved in the same folder as the Master file and each workbook needs to be called <Name of Tab+Prior Month+Year> so the first tab would be called "Tab Name April 2015". In addition, I want to set the the print area make it landscape orientation and break all links to other workbooks.
Everything I know about Macro's is from forums like these so I barely know what I'm doing! Any help would be greatly appreciated!
first of all, you have to understand that all the answers here are made by volunteers giving their free time helping others ..
with this spirit you need to understand that we can't do your job for you.
you have to search Kioskea.net for examples and similar questions, and you will be more than pleased, there's a lot of info and examples.
what I would recommend is that: