Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion Standard

Thu 21 Feb 2008, 16:49 Delegate Robert said...

Robert has attended:
Excel Advanced course

Macros

Can a Macro be used to incorporate other Microsoft Products.

Fri 29 Feb 2008, 14:46 Trainer Rajeev said...

RE: Macros

Dear Robert

Thank you for attending Excel Advanced course. I hope that it was beneficial to you!!

The short answer to your question is Yes Macros can be used to incorporate other Microsoft products.

You can record a Macro and copy and paste some data from Word to Excel. But if you are asking Macro to do something complicated to do then you do need some understanding of VBA.

To get more understanding of VBA you can always record a Macro and then choose [b]Tools > Macro> Macros

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Macros

Macros

RE: Macros

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010