I have a? 3.3 megs file that contains 12 tabs.? I need you to create a macro that will copy both the data + format + width? of colums + heights of rows into the following files.? Each file will contain parts of the main file and will be named as follows :
[login to view URL] : contains all tab except the STAFF tab
FA : contains the following tabs : Individuals + FA + Your branch
FSR : contains the following tabs : Individuals + FA + Your branch
Service? : contains the following tabs : Individuals +? Service + Your branch + Secret Weapon
I'm trying to make the files as small as possible, so please don't use the hide tab function.? i really need to copy into new workbook. once the macro has finish creating the 4 files it will return to the MAIN tab of the main file