Good day,
I need help pulling data from 3 tabs (Host, IP, Drive) into 1 new tab (Final Output) using Excel functions. Prefer not to use VB.
Data on Host, IP and Drive tab is pulled using ODBC. Data is automatically updated and refresh as new records are added / changed in the source database. Some records on IP and Drive tab will have multiple records for the same host (ServerX, ServerY, ServerZ).
Desired results:
The Final Output tab would have a row for every line of data from Host, IP and Drive tab.
The Final Output tab would dynamically update as new data was added / changed on Host, IP or Drive tab.
OS: Windows 7
Excel 2007
Thanks.
I need help pulling data from 3 tabs (Host, IP, Drive) into 1 new tab (Final Output) using Excel functions. Prefer not to use VB.
Data on Host, IP and Drive tab is pulled using ODBC. Data is automatically updated and refresh as new records are added / changed in the source database. Some records on IP and Drive tab will have multiple records for the same host (ServerX, ServerY, ServerZ).
Desired results:
The Final Output tab would have a row for every line of data from Host, IP and Drive tab.
The Final Output tab would dynamically update as new data was added / changed on Host, IP or Drive tab.
OS: Windows 7
Excel 2007
Thanks.