VBA - matching values and then copying range of cells in same row

Cantello

New Member
Joined
Sep 22, 2020
Messages
1
Office Version
  1. 2019
Platform
  1. 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:
1600768655316.png


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.

1600768828769.png

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! :)
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top