2 button , same macro

[chubbychub]

I want to have 2 buttons on different sheets for the same macro. this is what I have so far:

I have 1 button doing this:

Please Login or Register  to view this content.

But the same macro, I want to make another button doing the same thing, but in another sheet.
and this is what I have:

Please Login or Register  to view this content.

Please help, should be simple for someone who knows vba, thank you.

[Logit]

Please Login or Register  to view this content.

[chubbychub]

when I go view code, its in another sheet, and it don't seem to do anything. this first button is in 'inventory' sheet, and the second button I want it to be in 'summary' sheet.
should I open a new module?

[Logit]

Your code doesn't necessarily need to be in different modules. You can place the code in your initial post into a module, rather than the Sheet level.

[chubbychub]

ok, your code works, thanks, but could you give me direction on how you did that?
I go to 'design mode' then I 'insert' and I pick a button, from there what do I do?

[Logit]

To paste a button to the WorkSheet, select the button as you have already done ... move you mouse cursor to the location where you want the button ... and left click once.

A small window will appear, select the macro name that you want the button attached to and left click.

Voila !