So many macros

[robh0409]

Hi


I have managed to work out most of what I am trying to achieve through my own knowledge and by reading forums such as this but I cannot find what I am looking for unfortunately.

Basically I want to have a macro that will copy the information from a form to a different workbook but depending on month select a worksheet to enter that information into.

for example, if it was entered in May, then on the workbook it would enter that information onto the May worksheet


Thanks

 

[Luke M]

You'll want to store the information in a variable and then use that to select worksheet.

So, maybe something like this:

[pre]

Dim MyMonth as String
MyMonth = Range("A2").Value
Workbooks("Other Workbook").Activate
Worksheets(MyMonth).Select
'...

[/pre]

 

[robh0409]

thanks, I seem to have done it now