Dropdown boxes not updating cells

Hi,

Thanks for your reply, simple functions such as SUMMING, FORMATTING etc. and now ofcourse VLOOKUPS (just the basics though). No complicated programming or such things

I will see if I can attach an example with the relevant explanations.

Cheers,

Hi TMShucks,

I've attached the exact replica of what I want to use, the data contained is just dummy data for now until I can get the formula's sorted.

You will probably figure out what I want to do quite easily.

My main concern or issue I need to resolve is that the worksheet called 'REPORT' contains the dropdown list with centre names. However, when I select a specific centre from that list, the associated information should populate in the cells beneath it.

Do you know of an easy way that I can achieve this?

Thanks again for your help

Hi Again,

Thank you for trying, I appreciate it. I see what you say, the sheet is a bit complicating though, in essence, I could have used the report sheet only and do the same thing without having Sheet1 but the facility drop down still won't do what I'd like it to do.

The large table sounds like a good idea however I think at the end of the day, the most simplest thing to do is by just creating a seperate report page for each facility. That will be the easiest, then I can just reference the cells in each individual report using a VLOOKUP without any issues. It just means more multiple reports rather than a single report.

I'll keep a lookout and see if any other ideas come up. Thanks again so far for your help

Originally Posted by royUK

Your post does not comply with Rule 1 of our Forum RULES[/URL]. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Hi,

I am confused by what you mean with the above? I have changed the title of the post but how am I supposed to explain what my problem is? I find the instructions a bit vague.

Originally Posted by Skelvissie

Hi,

I am confused by what you mean with the above? I have changed the title of the post but how am I supposed to explain what my problem is? I find the instructions a bit vague.

I think they are referring to the prefix "please help" rather than just having the descriptive part of the problem.

I see, thanks for the tip, much appreciated.