Hi all,
i've searched the forum and other sources for answers and this has been answered in one form or another but do not necessarily fit my requirements (unless I overlooked a bunch of posts):
I have a Spreadsheet with 30 tabs - i'd like to extract 25 of those 30 into their own worksheets with the name of the new files being named after the sheet name. In addition i'd like the new files to be value and number formats as the original large file has ranges and each sheet references data from a raw data worksheet.
The current files have print ranges if that makes things easier to copy that range into a new worksheet. Every worksheet has a unique name (i.e. Brazil, USA, South Africa, China, etc..)
Looking for a macro to do all this and my VBA skills are minimal at best. Thanks in advance all!
i've searched the forum and other sources for answers and this has been answered in one form or another but do not necessarily fit my requirements (unless I overlooked a bunch of posts):
I have a Spreadsheet with 30 tabs - i'd like to extract 25 of those 30 into their own worksheets with the name of the new files being named after the sheet name. In addition i'd like the new files to be value and number formats as the original large file has ranges and each sheet references data from a raw data worksheet.
The current files have print ranges if that makes things easier to copy that range into a new worksheet. Every worksheet has a unique name (i.e. Brazil, USA, South Africa, China, etc..)
Looking for a macro to do all this and my VBA skills are minimal at best. Thanks in advance all!
