Hi,
I have a file (File A Sheet 1) that currently links to another file and is identical to (File B Sheet 2). File B Sheet 2 gets all the information from a lot of input files (Files C-Z). I want to get rid of File B, and make it so that in File A Sheet 1, each cell has all the links that File B Sheet 2 had to all the input files (File C-Z). Is it possible to do without manually changing each one of the links to the source files?
Thanks!
What about duplicating File-B and renaming it as File-A?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Or open files A & B, right-click on Sheet 2 in file B, select "Move or Copy" and then move it to File A
or Open both files, select all in sheet 2 in file B and copy / paste as formula in sheet 1 in file A
Click on the star if you think I helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
lordofthefart 
Register To Reply
Bookmarks