copy rows to another sheets using Drop down menu
Hi dudes.
I'm studying to take an international English Test. I made a excel file helping me to review some vocabularies on daily basis. but unfortunately I don't know how to program it . as you can see in the attached file, there is a reference sheet, by the name "vocab" which will be containing the whole vocabularies i wanna study. other sheets, from 1 to 30, illustrate days.
in the vocab sheet, in column A, I made a drop down menu, which contains 1-30, referring to days. I want when I choose each number from each column , the row which is related to it copies to the related sheet (from 1-30) completely. regarding to the, as I repeat this order (I mean using drop down list) in other sheets they follow the rule.
note: the rows are infinite not only 23 rows.
best regards
|