How can VBA be used to import certain ranges of data from one sheet to another depending on the value of a cell in the Active sheet

[Ayugma]

Hello,

I have the three sheets:

1) Feed Configurator
2) Data Sheet
3) 14ft Short

The Feed Configurator contains ActiveX controls with some macros that create the 3) sheet but isn't necessarily useful in this case.

The 2) sheet has all the data required for the 3) sheet.

When the Hand of Feed value (or cell D2) is "L", the Left Hand cells (from sheet 2) ) should be imported into sheet 3). When the Hand of Feed value (or cell D2) is "R", then the Right Hand cells (from sheet 2) ) should be imported into sheet 3).

Thank you for your assistance!

 

[Ayugma]

In case you need a reference to the sheet, its attached below!

Feed Configurator_FINAL.xlsm

 

[R2ah1ze1l]

if wsHandofFeed.Range("D2") = "L"
Take data from sheet 2 (left range) for new sheet 3
end if
if wsHandofFeed.Range("D2").value = "R"
Take data from sheet 2 (right range) for new sheet 3
end if

HTH