carlgren
08-14-2013, 08:56 AM
Hi,
I hope I can explain this easily!
I have a workbook with 19 sheets. The first is named MAIN. The rest are named A through R
on the MAIN sheet I have a data validation list containing the letters A through R. It's located in Range(AA5:AD5)
when a user selects a letter on the list I want to move specific columns from the selected (A through R) sheet onto the main sheet starting at Row 17.
So for example, a user selects B
I then want to copy cells from sheet B Range(B4:B103) to sheet Main Range(D17:D116) and sheet B range(E4:E103) to sheet Main(G17:G116) etc This will get done for 18 seperate columns.
my thoughts are that if I can determine which letter was selected in the validation list I should be able to simply copy the columns from one sheet to the other but I can't figure out how to determine the string value of what was selected.
any ideas would be greatly appreciated! :)
thanks
Don
I hope I can explain this easily!
I have a workbook with 19 sheets. The first is named MAIN. The rest are named A through R
on the MAIN sheet I have a data validation list containing the letters A through R. It's located in Range(AA5:AD5)
when a user selects a letter on the list I want to move specific columns from the selected (A through R) sheet onto the main sheet starting at Row 17.
So for example, a user selects B
I then want to copy cells from sheet B Range(B4:B103) to sheet Main Range(D17:D116) and sheet B range(E4:E103) to sheet Main(G17:G116) etc This will get done for 18 seperate columns.
my thoughts are that if I can determine which letter was selected in the validation list I should be able to simply copy the columns from one sheet to the other but I can't figure out how to determine the string value of what was selected.
any ideas would be greatly appreciated! :)
thanks
Don