Select cell that match from other sheet

I'm learning VBA and I want to create a ProjectUpdate for the Council.
I have long list in Column A in 'Summary' sheet and project update in 'George' sheet where they choose the project names in drop down list box.
Now, what codes will I put in, that whatever the name of the project they choose in list box, it will automatically activate the cell in Column A in 'Summary' sheet?

This is the code I've put in where they click on one of the color circle in 'George' sheet that represent the time of budget like red is alert, yellow is ok & green is good.

Please Login or Register  to view this content.

But at the moment, I just want to know how to activate the cell in 'Summary' sheet that match the list box in A4 cell in 'George' street so the color can automatically be filled in the cell next to the matched name in 'Summary' sheet

This is 'George' sheet
Project.jpg

and this is the 'Summary' sheet where the color will automatically filled in next to matched project whenever they click on buttons in 'George' sheet
Project2.jpg

Please ask any questions if you want more information. I'm doing my best to explain the situation, Thank you

Hi

Is there a unique key that will match up the selection made in George, with the items in Summary?


rylo

Hi

so where are the project names in Summary? From the picture, it looks as though the number is in column A, with the address in column B.

How about putting up a couple of small workbooks that match your structure, aims etc. Much easier for us to work with than pictures.



rylo

ProjectUpdateGeorget.xls

I hope the attachment is working because there's a red cross on the sign while uploading.
I wrote out the details in text box to explain in the attachment. Thank you in advance

Hi

See if this gives you some ideas....

Please Login or Register  to view this content.

rylo

Absolutely brilliant, thank you very much for this. Now, I have to add codes for every object (color circle) and that will take alot of time.

So rylo, how did you enter those codes. Did you use Record Macro, or did you just put in the codes from your head?
Like typing in

Please Login or Register  to view this content.

what does Range("A:A") sound for? I know there's A1 or AA1

So thank you very much again, this forum is the best.

Hi

Here's another approach. Put each of the relevant calling codes to the button (eg TimeRed is allocated to Oval 123). I can't see why you have to blank out the buttons - what happens if you make a mistake and want to correct it???

Please Login or Register  to view this content.

rylo

That's a good question but that's the way how my boss wanted it. He want to be able to see the result with "Project Update" where he can type in the details in the text box otherwise he'll have to change over to 'Summary' sheet to see the result from colors.

In the 'Summary' sheet, there will be 3 to 10 sections for one project each where each monthly report can be seen.

Also there will be at least 10 sections of those in 'George' sheet (with list boxes) because of monthly reports and that goes the same to other project sheets as well.

Yes, I know it's a lot of work but it's the best way to keep them happy.

So thank you again for such another good approach. Much appreciated mate.

I have tested your last code and it is so much more convenience, thank you. But it there any way the unchosen color circles for Time & Budget become blank? Like I made in the first post?
The reason is because my boss normally print the reports with details and it must show the color with Time and Budget.
Hope this make sense, Thanks.

by the way, I can see you have blank the color with unchosen circles for 'Time' and 'Budget' in the code

Please Login or Register  to view this content.

but it did'nt work

is there any way to manipulate this code so the unchosen circles become blank?

Thanks

Hi

Can't see why you have to rename them??? You should be able to just make them all visible. Create a macro that will go through them all and make them visible....

rylo