Please help with the following.
Within Excel….
I have cell data in a sheet, lets say A1 on sheet 1 – (Column is called Description)
I have a drop down list on sheet 1 in cell K1 – Same row
The drop down list is a list of other sheets (Sheet 1,2,3,4,5 etc.) in the same work book
I wish to select an item from the list (sheet 3, lets say), and then the cell A1 sheet 1 is then copied onto sheet 3 A1 (also called description)
This would be copied into the next available row. as the process is repeatable as sheet 1 grows with data
I have tried looking but I have never done VBA, I am however able to copy and paste, and I am pretty articulate and should understand any responses.
LeiHouns is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.