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.
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.