Combo Box problem

[Helgard25]

Hi,

I am using an Active X Combo box.

I have a list of six peoples' names that are in the combo box. If I select the different names I want the data connected to the specific names to be copied from the other sheet to my main sheet, help please??

[nathansav]

http://www.excel-easy.com/vba/exampl...ned-range.html

http://www.ozgrid.com/forum/showthread.php?t=11530

http://stackoverflow.com/questions/2...specific-range

These articles should give you what you need, you need to loop through the cells in the column, then check for name, then copy the row

[Helgard25]

Thanks a million will give it a go

[Helgard25]

Can you provide me with a sample, I am new at working with VBA

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[nathansav]

Dont they help? You only gave them less than 4 minutes

[Helgard25]

Here is the workbook

[Helgard25]

I want the Data on sheet "Bemarkers" Colums B-D to be copied to the main sheet if the different names are selected in the combo box

[Norie]

This should give you a start, put it in the Main worksheet's module.

Please Login or Register  to view this content.

[Helgard25]

Norrie Thank you very much, only problem now is I don't know how to do it myself. Is there a way you can explain to my why you did what you did?

[nathansav]

read the articles i sent and do some research After norie's explained, that is all you'll know how to do, start reading so you can do more. Think "what if my boss asks me to show the team how its done"

[Norie]

This finds the row the selected name is on in the sheet 'Bemarkers, which is also the first row of the data you want.

Please Login or Register  to view this content.

That value is used here for the start of the range we want to copy, which is in column B on the same row the name was found in.

Please Login or Register  to view this content.

In the above this part finds the end of the range we want to copy.

Please Login or Register  to view this content.

It does this by finding the row the next name is on, .Cells(Res, "A").End(xlDown).Row, and subtracting 1.