Macro Questoin

N

newguy

I am new to Macros and am trying to create one that takes information
and inputs it onto the next page via pressing a submit button. The
next time the input the information it needs to go on the next page.
The problem I am having is getting it to submit to the right page
instead of the same one over and over. The pages all have a unique
name which is a month and date so I just need help incrementing it
through the sheets. Thank you for any help that you can provide.
 
J

JMay

If your Target sheet (the Existing sheet that you wish to receive the
Copied data) IS ALWAYS IMMEDIATELY to the Right of the Source Sheet,
which has the "Submit button" on it then in a standard module paste in:

Sub foo() 'Assign this macro to your Submit button
ActiveSheet.Cells.Copy Destination:= _
Sheets(ActiveSheet.Index + 1).Range("A1")
End Sub

This should get you started
 
Top