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

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 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