ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I link one sheet of data to a template? (https://www.excelbanter.com/excel-discussion-misc-queries/78397-how-do-i-link-one-sheet-data-template.html)

Mike

How do I link one sheet of data to a template?
 
I have a spreadsheet that includes many "strings." These strings are
healthcare plans including deductibles, coinsurance, max out of pockets etc.
What I want to do is link these to an excel template, that our company uses,
so that when I enter the string title the template will automatically fill in
the information that is in the string.

So for example on the template, if the string was titled LIK; all I would
have to do is type LIK into one of the cells on the template and it would
just fill in the rest of the spreadsheet.

Any help would be greatly appreciated.

Thanks,

Mike


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com