![]() |
Worksheet name
I have a workbook with sheets named, Summary, 8jan, 15jan, 22jan,
etc... In 'Summary' A3 I have ='8jan$j$5' I would like some way if possible to inrement A4 and so on automaticaly to the next sheet in line. So A4 would read ='15jan$j$5' since 15jan is the next sheet. I assume this may be easier to do if the sheet names use numbers like 0108, 0115 or something, if thats is required then thats So is there a way to go about doing this? Thanks for any help you guys can provide. |
All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com