H, all. I tried searching for this, but came up with blank, white pages instead of results. Sorry if it's been brought up before, but if you can point me in the right direction, I'd be highly appreciative.
I've got a file with a range of information, and then a newer version of that file. I need to import the information from the named cells of the old file into the same named cells in the new one. The data is spread over multiple pages, and the pages are named the same on the new file.
I know nothing of VBA and would like to do this without it if possible, but I know it'll probably happen.
I'm running Excel 2007 and tried working through Name Manager, but that didn't work. Neither did the External Data Connection - it just made my new file gobbledeegook on the one cell it replaced and wanted to redesign the whole sheet.