Macro Button

[johnnydop]

I have a worksheet with two tabs. Tab1 has a macrobutton that runs a macro off of the data from Tab2. I recently created another macro within Tab2 and added a second button back on Tab1 however i dont know how to update the code so that my second macro runs off the data in Tab2 and not in Tab1, where its located. Make sense?

 

[John Davis]

I have a worksheet with two tabs. Tab1 has a macrobutton that runs a macro off of the data from Tab2. I recently created another macro within Tab2 and added a second button back on Tab1 however i dont know how to update the code so that my second macro runs off the data in Tab2 and not in Tab1, where its located. Make sense?

In your new code for the second button, you probably need to Sheets("Tab2").select at the beggining so that the code will operate on Tab2.