Cantello
New Member
- Joined
- Sep 22, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi all!
I am a little bit stumped here (or completely out of my league, fits better) - I wanted to have drop down menus and then copy parts of rows with matching data to another worksheet for editing. Originally, I wanted to use INDEX/MATCH, which worked well until I realised (yeah, great thinking ahead) that I have no way of editing the values that have been copied and put them back into the main worksheet from where they have been copied.
So I thought about VBA - this should be doable, right?
Could you give me a hint on where I should start looking/googling? First problem is matching all rows with a certain data (classes in this case) and then copying only some columns of this row over to the 'display worksheet' for editing.
My data is organised approximately as follows:
Which should then be copied to the 'display worksheet' roughly as follows (i.e. copy the first two columns of rows with matching class and then additional columns with the matching subject). The order of subjects is fixed so I can simply use a number corresponding to each subject to find the necessary columns - this way I only have to match one data (class) and not a second.
I would the use a second function to copy the edited data back to the main worksheet.
Any ideas, tips or websites that could explain this sort of things?
Thanks!
I am a little bit stumped here (or completely out of my league, fits better) - I wanted to have drop down menus and then copy parts of rows with matching data to another worksheet for editing. Originally, I wanted to use INDEX/MATCH, which worked well until I realised (yeah, great thinking ahead) that I have no way of editing the values that have been copied and put them back into the main worksheet from where they have been copied.
So I thought about VBA - this should be doable, right?
Could you give me a hint on where I should start looking/googling? First problem is matching all rows with a certain data (classes in this case) and then copying only some columns of this row over to the 'display worksheet' for editing.
My data is organised approximately as follows:
Which should then be copied to the 'display worksheet' roughly as follows (i.e. copy the first two columns of rows with matching class and then additional columns with the matching subject). The order of subjects is fixed so I can simply use a number corresponding to each subject to find the necessary columns - this way I only have to match one data (class) and not a second.
I would the use a second function to copy the edited data back to the main worksheet.
Any ideas, tips or websites that could explain this sort of things?
Thanks!