Macro problem

[stemby]

I have a spreadsheet with a number of worksheets (named 'year1', 'year2', etc) which hold data for things like stock held, etc for all the weeks in a year.

I have designed an 'input' worksheet, where I would like to input the current year, the week number I'm up to, and the stock figure for that week. I would then like to click on a 'enter figures' button, where a macro would copy my data from this 'input' screen to the relevant workbook and 'week' row.

My question is: If I have cell A1 on my 'Input' worksheet containing 'year2' and A2 containing '49', how do I construct a formula/macro to goto a worksheet called 'year2' and a row, say, 49?

Any help would be gratefully received, bearing in mind I'm very new to all this macro stuff. Thanks

[Corni]

If sheets in the workbook are "Input", "Year1", "Year2", etc. then assign this macro to the button:
Worksheets("Year" & Worksheets("Input").Cells(1, 1)). _
Cells(Worksheets("Input").Cells(2, 1), 1) = _
Worksheets("Input").Cells(3, 1)

[stemby]

Thanks for the reply, but I still can't get it to work. As I'm VERY new to macros, could you please explain the logic behind the code you gave me so I can try to understand it better.

Thanks

[Ivan F Moala]

On 2002-03-17 11:32, stemby wrote:
Thanks for the reply, but I still can't get it to work. As I'm VERY new to macros, could you please explain the logic behind the code you gave me so I can try to understand it better.

Thanks

Try this code and attached it to a shape or button

Sub GotoSheet()
Application.Goto Sheets(Range("A1").Text).Range("A" & (Range("A2").Value)), True
End Sub

Ivan