dgl_thrawn
New Member
- Joined
- Jan 19, 2005
- Messages
- 6
I have a workbook with various named sheets (eg AM38-03-037-A) and a contents sheet with a list of these sheets exactly as they appear on the sheet name tab. As these sheets have issue numbers and need to be up-issued occasionally, I'd like to be able to have a macro run for each item that will look up the sheet name in the relevant cell and go to that sheet. At the moment I have to type the sheet name into the macro. I currently have:
Sub Button38_Click()
'
' Button38_Click Macro
' Macro recorded 19/04/01 by David Lawrence
'
'
Sheets("AM38-03-037-A").Select
End Sub
If sheet AM38-03-037-A is up-issued to AM38-03-037-B, I have to manually change it. If that change is already typed into a cell (say A37) on the contents sheet, can I refernce the contents of the cell instead?
I am using Excel 97.
dgl_thrawn
Sub Button38_Click()
'
' Button38_Click Macro
' Macro recorded 19/04/01 by David Lawrence
'
'
Sheets("AM38-03-037-A").Select
End Sub
If sheet AM38-03-037-A is up-issued to AM38-03-037-B, I have to manually change it. If that change is already typed into a cell (say A37) on the contents sheet, can I refernce the contents of the cell instead?
I am using Excel 97.
dgl_thrawn