Fri 10 Oct 2008, 16:24Delegate Jesse said...
Jesse has attended:
Excel Intermediate course
Excel Advanced course
Macros
how do you create a macro so you enter data on onme file, and it is entered in a different way on several other files?
Mon 27 Oct 2008, 15:42Trainer Amanda said...
RE: macros
Hello Jesse
Thank you for your question and welcome to the forum.
When you go to run a macro, you have the option of selecting Macros in: All Open Workbooks.
That way if you have created and saved a macro in one workbook you should be able to access and run it in other workbooks, provided the workbook you created it in is open at the time when you want to run the macro.
I hope this helps to answer your question.
Amanda
