Macros

Resolved · Low Priority · Version 365

Thu 7 Apr 2022, 09:28 Delegate Rosina said...

Rosina has attended:
Excel Intermediate course
Excel Advanced course

Macros

Hi, please can I have further assistance with Macros as I can't get them to work.

Thu 7 Apr 2022, 09:56 Trainer Marius said...

RE: Macros

Hello Rosina,

Thank you for your question. In order to assist you better, please could you tell us what specifically isn't working in your macros? If you need to send us an attachment, you can email us at:

info@stl-training.co.uk

Kind regards
Marius Barnard
STL

Fri 12 Jan 2024, 00:33 Trainer Rich said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips