Macro Help

[ai1094]

Hello,

So I have a few macros that I recorded/created. I want to assign my macro to a button and when a user clicks that button, it will run on a specific worksheet within the workbook.

For example:

I downloaded an extract from a dashboard that converts the data into an excel file. The problem is that data is unorganized and hard to read. That is where my macro comes in play. My macro organizes the data accordingly. So what I want to do is download that data, copy it into a new worksheet where my macros are located and I want the user to be able to click one of my button options and it will format the data.

Does anyone know how to go about this? I know it's probably simple to do by declaring variables but I'm not sure how to write it myself.

 

[Joe4]

You can get to a specific sheet in VBA like this:
Sheets("SheetName").Select

Is that what you are after?

 

[Yongle]

looks like you have duplicated your thread over here

 

[Joe4]

I wasn't sure if the original question was just how to get it to:

run on a specific worksheet within the workbook.

or if they were talking about the whole macro.

In any event, if it is the same question that was asked again and answered, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules). If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.