How do I link with certain aspects?
Ok... here's what I need to do. My company has MANY spreadsheets, currently,
that house our data. We record all aspects of our project in Excel and run
all of our reports in Excel as well. I need to know if there is a way to
link 1 spreadsheet to ALL of the spreadsheets that we have so that it will
pull data by a specific range (i.e. date, time, etc). Is this possible?
What is the formula for that?
|