Snappleton
New Member
I may be using the wrong terminology with "Link" but that is what I think of with this.
What I am trying to do is to link data from one file to another so that in the second file I can remove certain data points. That in itself is simple with just a = and then the cell in the other file then delete cells I don't want to share. Thing is, the original file has nearly 6,000 cells and I want to do this monthly and not have to recreate it each month. Perfect solution would be that I enter the file name of the copy from file into the copy to file and it would populate.
Any help is greatly appreciated.
What I am trying to do is to link data from one file to another so that in the second file I can remove certain data points. That in itself is simple with just a = and then the cell in the other file then delete cells I don't want to share. Thing is, the original file has nearly 6,000 cells and I want to do this monthly and not have to recreate it each month. Perfect solution would be that I enter the file name of the copy from file into the copy to file and it would populate.
Any help is greatly appreciated.