splitting several tabs specific
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Splitting several tabs by a specific criteria from one workbook,

resolvedResolved · Urgent Priority · Version 2003

replyReply Wed 10 Aug 2011, 17:02Delegate 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

For upcoming training course dates see: Pricing & availability

replyReply Mon 15 Aug 2011, 19:16Trainer 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

 

Excel articles

· What Do The Formula Error Messages Mean In Excel?
· Make Things Easier In Excel With Lists
· Discover The PMT, IPMT And PPMT Functions In Excel
· Creating Top Tables With Excel
· How Excel Can Transform All Of Your Office Documents

Please browse our web site to find out more about
advanced+excel+training+in+london and other Microsoft training courses.

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy