Excel Excel Macro

M

MarinoFan

Joined
May 26, 2013
Messages
2
Reaction score
0
I am fairly new to building macros and have been able to build some fairly simple ones, but I need help with this new one. I have an excel sheet with two columns that goes down several rows with two unique numbers and a separate sheet with two boxes that will create a chart when the two numbers are put into the boxes. I need a macro to grab the two numbers in each row, put them into the two specific cells while moving it to a a new sheet and continue down the rows until a chart has been built for each row. Thanks ahead of time for your help.
 
MarinoFan,

I'd like to help with this but I'm confused by your description. How will the macro know which two cells to fill with data on the second sheet? Is there a separate chart for each pair of numbers or is this all one big chart? If they are different ones, is each one on a different sheet?

Cheers.
 
Back
Top