repetitive task

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Repetitive task

Repetitive task

resolvedResolved · Low Priority · Version 365

Ryan has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Word Intermediate course

Repetitive task

I log into a monitoring database via excel plug-in to access our portfolio companies monthly data and run through standard steps to send some data outputs to the portfolio companies Wondering if I can use the 'record macro' function to automate this procedure each month.

RE: Repetitive task

Hi Ryan,

Thank you for the forum question.

I do not believe that you can record the task. The recorder can only record what you can do in excel worksheets.

The task can be automated. I automate tasks like this by writing VBA codes or I use Power Query.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.06 secs.

✓ w3speedster