VBA Macro To Copy Cell Data Dependant On Option Selected From Drop Down On The Same Row

Hi,

Wonder if anyone would be able to help, I’ve exhausted my knowledge

I have a table B2:E12.

Columns B-D have numbers, in column E there is a dropdown with the option to select numbers 1-12 from the list.

I need a code so depending on what number you select from the dropdown in column E it copies the information from columns B-D of the same row into another table so they all group.

I need all the option 1’s to start filling from column B-D, row 50
I need all the option 2’s to start filling from column B-D, row 100
I need all the option 3’s to start filling from column B-D, row 150
.. and so on.

Is this even possible?

Thank You

Yes, it should be possible. Can you provide a sample file to work with? Are the tables them same staring down at row 50, 100, and 150? And Will the data every surpass each section. ie, will Option 1 ever reach rows 99 and 100 and then overlap that area?

Hi,

Sorry no file at the moment.

The tables will be the same starting at row 50 100 and 150, they will never surpass one another.

Thanks

Does the Table have a header row for column names and will those column headers be included in each section starting on rows 50, 100, 150, etc?

Hi,

Yes, there is a header row on each table, all the same.

Thanks

This should help get you started, but if you have a sample it would be better. And you can decide if you want to use a drop down or some other data validation for 1 - 12.

Please Login or Register  to view this content.