98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Repetitive task
Repetitive task
Resolved · Low Priority · Version 365
Wed 5 Jun 2024, 16:47Delegate Ryan said...
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.
Thu 6 Jun 2024, 17:27Trainer Jens said...
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
Training information:
See also:
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:##### displaying in ExcelWhen 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. |
