How do I hide range of data imported from another sheet based on the values of a cell?

[DreyFox]

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.

 

[Zot]

The Master sheet is now L, but I have no idea what has been imported to Master sheet from Left Hand Feed Rail. Where data is imported to?

 

[DreyFox]

The Master sheet is now L, but I have no idea what has been imported to Master sheet from Left Hand Feed Rail. Where data is imported to?

Sorry if I wasn't clear enough, but I would like to import data from the "Data" sheet into the Master sheet depending on the value of the "Hand of Feed" cell

 

[Zot]

Sorry if I wasn't clear enough, but I would like to import data from the "Data" sheet into the Master sheet depending on the value of the "Hand of Feed" cell

Yes. It is just I did not see on current sample where the data on Master sheet came from. The data does not seems to be from Left Hand Feed Rails, Right Hand Feed Rails or HC95SA Selection.

So, it is difficult for any forum member to help with any VBA code or whatever. The question was also asking on how to hide range of data. What are you trying to hide?

 

[DreyFox]

Yes. It is just I did not see on current sample where the data on Master sheet came from. The data does not seems to be from Left Hand Feed Rails, Right Hand Feed Rails or HC95SA Selection.

So, it is difficult for any forum member to help with any VBA code or whatever. The question was also asking on how to hide range of data. What are you trying to hide?

So I have this Master sheet:

On the Data Sheet we have the following data for the Left Hand Feed denoted by "L" and the Right Hand Feed denoted by "R":

So when we have "L" denoted on the Master Sheet, the Data in the Left Hand Feed Rails will be imported into the Master sheet, however if we have "R" denoted on the Master Sheet, the Right Hand Feed Rails will be imported into the Master sheet.

 

[Zot]

I saw L in Master sheet.
Feed Size = F14
Drifter Selection = 955

What I cannot understand was where those F14 and 955 came from. It is not in Left Hand Feed Rails table shown. Where in the Left Hand Feed Rails the Master sheet imported the data from? Sorry, I still could not get it.

In Master sheet you have Jumbo, Striking Bar, Drill Steel Size, etc. These need to fill in too? If yes, where are data to be imported?

 

[DreyFox]

I saw L in Master sheet.
Feed Size = F14
Drifter Selection = 955

What I cannot understand was where those F14 and 955 came from. It is not in Left Hand Feed Rails table shown. Where in the Left Hand Feed Rails the Master sheet imported the data from? Sorry, I still could not get it.

In Master sheet you have Jumbo, Striking Bar, Drill Steel Size, etc. These need to fill in too? If yes, where are data to be imported?

I'll try to be even more specific. The data from the Data Sheet for the column A1 should be imported in A1 of the Master sheet when L or R is entered.

The Jumbo, Striking Bar, Drill Steel Size and others will be manually filled by me, as there are only 2 options for them.