I have several budgeting workbooks in Excel 2003 that are used by my companies field staff to input data. The inputs they choose within the header creates a unique budget number and each tab within the workbook represents a single unique budget. I currently have the field staff "copying" and "pasting" the unique budget number from the cell where it resides to the Tab name in order to clearly identify that tab within the workbook. Can this process be automated? I could create a macro button to perform the task but thought it might simply be able to be automated and I can't seem to figure out how to do it...
Thanks in advance for any guidance even if it is to tell me it can't be done!
Thanks in advance for any guidance even if it is to tell me it can't be done!