|
|
|
|
#1
01-26-2018, 12:27 PM
|
|||
|
|||
Why such complicacy?
In a single excel workbook, on one sheet create a table of all materials - with material as leftmost column, and other parameters for material in same row. In another sheet, you have formula(s) table, where one column is for material. You enter there a material (in same format as in leftmost column of materials table, and all parameters for this material are read into next columns using Excel VLOOKUP() formulas. 
|
|
| Tags |
| hyperlink, path |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Hyperlink to open another sheet in same workbook with filtered data
|
tarunbaweja | Excel Programming | 1 | 03-20-2016 06:52 AM |
| Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore | quanghuynguyenhua | PowerPoint | 0 | 10-10-2015 06:17 PM |
| How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
| Enabling the undo function in a macro enabled workbook | jpb103 | Excel Programming | 4 | 06-05-2014 08:56 AM |
| changing default program from works to word to open attachments | catskier | Outlook | 0 | 03-10-2009 01:35 PM |
Windows 8 
Office 2016
Hybrid Mode