Hello!
I have to import a range of data from one sheet to another sheet depending on the values of the master sheet. So:
Master Sheet - contains a set of values that change. Image shown:
Data sheet:
So, what I would like to achieve is that if say the "Hand of Feed" cell is L, then the Left Hand Feed Rail data will be imported to the Master Sheet, if it is R, then it will import the Right Hand Feed Rail data into the sheet. If it is empty, nothing will happen. Similarly, in Additional Options, if say A gets removed and the value is only DHELQR, then the Hose Bulkhead data will appear on the Master Sheet. If A is still there, then the Hose Bulkhead data would not appear.
Any help would be greatly appreciated.
I have to import a range of data from one sheet to another sheet depending on the values of the master sheet. So:
Master Sheet - contains a set of values that change. Image shown:
Data sheet:
So, what I would like to achieve is that if say the "Hand of Feed" cell is L, then the Left Hand Feed Rail data will be imported to the Master Sheet, if it is R, then it will import the Right Hand Feed Rail data into the sheet. If it is empty, nothing will happen. Similarly, in Additional Options, if say A gets removed and the value is only DHELQR, then the Hose Bulkhead data will appear on the Master Sheet. If A is still there, then the Hose Bulkhead data would not appear.
Any help would be greatly appreciated.