Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Splitting several tabs by a specific criteria from one workbook,

Splitting several tabs by a specific criteria from one workbook,

ResolvedVersion 2003

Wed 10 Aug 2011, 17:02 Delegate Radika said...

Radika has attended:
Excel VBA Intro Intermediate course

Splitting several tabs by a specific criteria from one workbook,

I have a source data worksheet, with multiple tabs.

I am trying to:
1)select 5 of the tabs by a certain selection criteria
2)save separate workbooks, showing the 5 tabs, which each show the specific criteria separately

please contact me as soon as possible.

Many thanks
Radika

0207 063 7574
radika.abeydeera@bnpparibas.com

Mon 15 Aug 2011, 19:16 Trainer Simon said...

RE: Splitting several tabs by a specific criteria from one workb

Hi Radika,

Can you please send more detail regarding the criteria needed to select the tabs.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Splitting several tabs by a specific criteria from one workbook,

Splitting several tabs by a specific criteria from one workbook,

RE: Splitting several tabs by a specific criteria from one workb

Excel articles

Excel tip:

Importing Numbers in Excel 2010