I would like to rename 228 sheets with the teams listed in cell b2:b229. The sheets already exist and are based off a template.
The template has two cells that are web queries. ("Template" i25 for column D and "Template" ac25 for Column E)
These web queries are listed in columns D and E and are associated with each team.
Can someone help me with renaming these 228 sheets and searching their respective queries? Doing this manually without VBA would take me a month.
Once inside the query I select "disable date recognition" so that my data does not show up as dates. Will this cause problems?
Thanks for your help.