Copy and Paste from Different Sheet base upon Drop Down Criteria

[Scotnroa]

Hi Folks,
This should be easy, but it's been to many years since I've done anything in VBA. Thanks for any guidance or help.

I have a Worksheet that has two Sheets. "Data" and "Input". Column "A" of Input has a Drop-Down List from Column "A" of Data. When the Drop Down is activated, I need The Row that corresponds to the value in the Drop down to copy columns "B, C, D" from Data to Input Columns "B, C, D". I can do this simply with xlookup but I need to formulas to transfer also.

Thanks,

Scott

 

[Joe4]

Welcome to the Board!

I can do this simply with xlookup but I need to formulas to transfer also.

I am not sure what you mean by "I need to formulas to transfer also".

I am also unclear why your XLOOKUP solution will not work for you?
It seems to do what you want, doesn't it?
What is it lacking?

 

[Scotnroa]

Thanks for the reply. I finally figured out a solution that worked. The xlookup only copied values and not the formulas as I was wanting.

Thanks again

 

[Joe4]

I am guessing that there was a level of detail missing in your question that made it not too clear exactly what you meant.

Would you mind posting your solution? I am curious. It might shed some light on what you were dealing with and what you were trying to do.