Hi there - VBA newbie here! - i have a workbook with 5 worksheets.
Worksheet Names are:
- Sheet5
- Sheet4
- Sheet3
- Sheet2
- Summary
I am looking for a VBA that will do the following:
- rename Sheet5 with cell reference (A5) on Summary sheet
- rename Sheet4 with cell reference (A4) on Summary sheet
- rename Sheet3 with cell reference (A3) on Summary sheet
- rename Sheet2 with cell reference (A2) on Summary sheet
Would appreciate any assistance you can provide!!
Bookmarks