<div>
vincem1099 - you are brilliant, a genuis, and indeed, a MASTER. Thank you for sharing your expertise with me!
</div>


vincem1099 - you are brilliant, a genuis, and indeed, a MASTER. Thank you for sharing your expertise with me!

<div>
<div class="content wysiwyg-content">
Is it possible to link data from 1 workbook to be housed on a shared drive using a named range for 2 columns (Name and Project) to a 2nd workbook that will be housed in a database?<br />
<br />
I hope to use a named range so that any updates to the 1st workbook will automatically be reflected on the 2nd worksheet when the user opens the 2nd workbook.<br />
<br />
My ultimate goal is to use the linked data in the 2nd workbook along with other like data (Name and Project) in the 2nd workbook to create a pivot table displaying all Projects for each Name.<br />
<br />
Many thanks, in advance, for your guidance.<br />

</div>
</div>


Is it possible to link data from 1 workbook to be housed on a shared drive using a named range for 2 columns (Name and Project) to a 2nd workbook that will be housed in a database?

I hope to use a named range so that any updates to the 1st workbook will automatically be reflected on the 2nd worksheet when the user opens the 2nd workbook.

My ultimate goal is to use the linked data in the 2nd workbook along with other like data (Name and Project) in the 2nd workbook to create a pivot table displaying all Projects for each Name.

Many thanks, in advance, for your guidance.


Linking Excel workbooks using named ranges to create a pivot table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.