I have a question regarding referencing. I am trying to reference to different worksheets. Currently, I have daily worksheets and their names are basically in mmddyy format, i.e. 071606 for July 16, 2006. I need to lookup (or reference) to these worksheet, but I don't want to look them up individually - i.e., clicking to the worksheet and to the cell one by one. Is there a easy way to do this? I can list all dates, convert them to text so it matches the individual worksheet names, but I cannot use this text string in referencing. Thanks!
2006-07-18
23:32:31
·
3 answers
·
asked by
heuiim
2
in
Software