I want to be able to trigger a macro in Sheet 2 every time cell with range f2:g2 changes on Sheet 1. Can anyone help?
I want to be able to trigger a macro in Sheet 2 every time cell with range f2:g2 changes on Sheet 1. Can anyone help?
I am not sure I understand your problem
Is the macro specific to sheet 2
Or is it simply that you want to switch to sheet 2 before running the macro?
Right Click on the sheet name "Sheet1" at the bottom of excel
Paste this code in the window that opens and close that window.
The macro will run if you change F2 or G2
It will switch t sheet2 and run Macro1
Please Login or Register to view this content.
Last edited by mehmetcik; 06-06-2015 at 09:00 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Yes, the macro is specific to Sheet 2. But I want that macro to run whenever Cell F2 on Sheet 1 changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks