Run different parts of a macro on same sheet

**donkey1** · 09-20-2012, 10:50 AM

Now that xladept gave me the info to create a macro, i got another request. You know what they say about giving a mouse a cookie...

Anyways I need to take the macro i created and run the codes in it separately. I know I can set a breakpoint when I'm in there editing the code. However I want to create a button to run each part of the macro. In other words, I'll have two buttons for the code below; one for product A and one for product B. This is all on one sheet and I can't split the sheets.

Here's the code:

Please Login or Register  to view this content.

**patel45** · 09-21-2012, 02:02 AM

it's a very bad code, explain what is tour goal, attach a sample file with current and desired table

**donkey1** · 09-21-2012, 03:08 PM

my goal is to copy and paste to fill in today's new data. everything is on one sheet so right now i have a macro that does all the products in one run but i want one run to only populate one product. i want to create a button for each product that initiates the running of the code. all the products are on one sheet

Test for data.xlsm