Hi all,
I have two Excel files, one contains our data, and the other is from our source. The source data needs to be transferred into our file. The source file contains 58 sheets of data which needs to be moved to our file. The layout of each sheet in the source file is consistent with the layout in our file (thankfully). The problem is, the sheet names in the source file do not match the sheet names in our file.
Our file has sheet names "1","2",..."58". A straight up number sequence
The source file sheets names are: "tab01-eng","tab02-eng"..."tab58-eng".
This (to me at least) poses a problem.
I was wondering, is it possible to remove all text from the sheet names and leave just the numbers without going at it manually? I've been trying to re-name the sheets based on the number values inside the name but have not been successful. As always, any help is greatly appreciated.
Regards
Bookmarks