Pulling data from a different workbook
I think I know how to do this, but there also seems to be several methods and I want to know which is best. I pasted a simple example below. Basically, I will have a workbook already made (on the left) and I want to create a new workbook that will pull data from it as shown below (I may want cell A1 on the new workbook to pull from cell A2 and want it change if I change it on the original workbook). First, what is the easiest method to do this? Secondly, what do I need to be aware of (such as will it affect things if any of these files get relocated)? And finally, in my original workbook, I tend to add columns to it frequently. A good example will be in this one shown, I will eventually add May to column E. When that time comes, I would like to just be able to copy D1 over to E1 in the new workbook and have it know that I want it to actually pull from E2 rather than from D2.
[link] [comments]
Want to read more?
Check out the full article on the original site