ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet name (https://www.excelbanter.com/excel-worksheet-functions/9101-worksheet-name.html)

jm

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