Hi,
I'm very new to Excel and my boss has given me the challange of amending one of our timesheet excel documents.
I need to create a dropdown menu to change one of the figures within the table to one of 4 different numbers according to which dropdown option they choose. I've had a look through various list and filter functions, but I'm having no luck so far.
Forgive me if this is really basic stuff, but I am still learning!
Thanks for your help.
Last edited by Smithy_Jones; 01-18-2012 at 11:16 AM.
Welcome to the Forum.
Please attach a sample workbook so we can help you better.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Possibly Data Validation lists
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Hi,
Thanks for the tip. The Validation lists are really useful!
Now i'm trying to use an 'IF' Function.
Does anyone know how I'd use an 'IF' function just to calculate a figure if the cell reads a certain text?
Thanks again!
Is this related to the dropdowns question? If it is, you can continue here. Otherwise, it would be advisable to mark this thread solved and start a new thread with your question.
Also, please provide an example of your calculation so we can help you further.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
HI,
No problem, i'll start a new thread with the 'IF' query.
How do I mark a thread as 'solved'?
Thanks
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks