excel.training.course.london - series actions
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 Training and help » excel.training.course.london - Series of actions

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

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

Training information:

See also:

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.

excel.training.course.london - Series of actions

resolvedResolved · Low Priority · Version Standard

replyReply Wed 9 Jan 2008, 11:27Delegate Christof said...

Christof has attended:
Excel Advanced course

Series of actions

Can I program and save a series of actions?
Example: I get the same Excel list of data every day and need to manipulate it in the same way every day. Can I save a string of actions to automate the process? like change date format in column A D and F and sort ascending in column B then save in Folder XYZ as filename "current date" ...

Thanks in advance.

For upcoming training course dates see: Pricing & availability

replyReply Wed 9 Jan 2008, 14:36Delegate Paul said...

RE: Series of actions

you can carry out most of that by creating a simple macro and attaching it to a button.

The 'save as...' bit requires a bit of VB code...

 

Excel articles

· Adding Effects To Drawing Objects In Excel
· How To Manage Your Everyday Spending In Excel
· Customized Financial Excel Courses in London
· Automatically Insert The Time, Date Or Both In Excel
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

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