Hi I am trying to create an active list with excel that will automatically copy a row to the next available row on the selection of a option from a dropdown list. Can this be done?
Auto copy row to next available.
0
Discussion
Please include a sample file that shows what you are trying to do.
MRVMV (rep: 52) Jul 14, '16 at 12:04 pm
Hi, thank you very much for your prompt response. I am not sure exactly how to attach a sample file in this forum. Basically I have a list of names in column A as follows:
A B
John Smith Confirmed
Pete Burns
Fred Flintsone
Barney Rubble
John Smith
I want to then create a dropdown box in column 'B' that when the drop down option 'confirmed' is selected the name in column 'A' will automatically copy to the bottom of the list in column 'A'.
Do you think this is possible?
Thanks again for your response and I appreciate any help you can give.
A B
John Smith Confirmed
Pete Burns
Fred Flintsone
Barney Rubble
John Smith
I want to then create a dropdown box in column 'B' that when the drop down option 'confirmed' is selected the name in column 'A' will automatically copy to the bottom of the list in column 'A'.
Do you think this is possible?
Thanks again for your response and I appreciate any help you can give.
gstar717 Jul 20, '16 at 6:44 pm