Guys I need your help either vba code, excel formula or steps in creating my template. for instance i have workbook with 4 sheets(1,2,3,4) and every sheet(2,3,4) has 3 columns. Now i want to create in sheet1 a group of columns. For the first three columns i want a dropdown list say, s2,s3,s4, and if i pick s3, it will copy the values/formula on the three columns from sheet3 and doing the same thing for the next 3 columns and so on. Is this possible to do or are there any alternatives? Thank you. Any help is appreciated
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dropdown list to insert multiple columns from one sheet to another
- Thread starter lecnad
- Start date
