Macro Button in Sheet 1 performs action in Sheet 2

[cymraeg]

My question concerns the operation of a macro when it has been assigned to a button. Is it possible to place a macro button in sheet 1 of a 2 sheet workbook, and have it operate the macro on the raw data in sheet 2 ? If yes how would I go about doing that ?

[TMS]

Just fully qualify all range and cell references.


Regards, TMS

[cymraeg]

Many thanks for the quick reply.

However as I am a complete novice with macros, could you explain how I would do that.

Regards,
Cymraeg

[TMS]

Hard for me to explain when I don't know what your workbook, worksheets or data look like, nor what you want the macro to do.

Do you have any code that already works on a sheet ... you just wish to initiate it by pressing a button on another sheet?

Full qualified would look something like:

Please Login or Register  to view this content.

Regards, TMS