CopyRange to another sheet based on combobox selection

[anonyms]

Hello everyone,

I hope you can help me out. I have a workbook which has 12 sheets named by Month in order. Each sheet is identical format wise and has a list of 20 buildings written in Range H11:AV11. I am trying (and failing so far..) to create a macro, that based on my UserForm with 2 comboboxes selection (1 selection: Month - would select sheet, 2nd selection - Building) and once pressed the button would copy special (values) from source (in January sheet range G14:G41) to respective selected sheets location - Building 1 paste destination is cell H14, Building 2 - J14 (2nd cell from the Building 1) and so on.

Hopefully it makes sense and you can put me on the right track.

Thanks for your time reading.
Min.

[AlphaFrog]

Read it a couple of time and I can't figure it out. The month sheets have Buildings in H11:AV11, but you copy from G14:G41. I don't get it.

[anonyms]

Hi. Yes, G14:G41 in January sheet is my source where I need to get values copied from to underneath a building name. If Combobox selection is Building 1 (location H11), then copied values from G14:G41 in cell H14, if Building 2 - J14, if Building 3 - L14 in respective sheets i.e. January, February..

[AlphaFrog]

Try something like this (if I understood you correctly). It uses the list index if the selected building to determine the column offset from H14 e.g; Building 1 has a list index of 0 so there is no offset. Building 2 has a list index of 1. That is multiplied by 2 and it is used as the offset from H14 to J14.

Please Login or Register  to view this content.