Excel Q&A

Home

Forum

Advanced Excel Topics

Excel Q&A
- Excel Q&A

Ask your geeky hard core Excel questions here!

Questions/Discussions

Sort by Date ▼ / Top Rated

Toggle Reference File Links

I am trying to pull in data from different workbooks that have data sorted by month and worksheets sorted by division. For example, the file name could be: “Product Line by Division 10.13” for October 2013 and the tab name could be “NE Vermont”. How can I pull the same information from the �... Read More

Show All 2 Replies Login to Reply

by Guest 1.

added 11 years ago

Re: Toggle Reference File Links

Hi, Thank you for your inquiry. Yes, this is doable fairly easily, combining a bunch of various tools in excel. While we generally discourage linking between files, we can understand why you want to in this case. Here’s how we’d go about it. Assume you’re working in a new file, called “Ro... Read More

by WST Expert 1.

added 11 years ago

Show More Show Less