Select September From My Drop Down, Only 30 Days Will Show
Nov 6, 2008
I have a form for people to submit their monhthly total number of hours worked.
At the top of the form the user will write their details etc followed by selecting which month of the year it is (in the form of a drop down menu).
In cells D24 to D54 I have numbers 1 to 31 to represent the min and max number of days in a month.
Is there a way I can structure my form so if I select September from my drop down, only 30 days will show?
View 9 Replies
ADVERTISEMENT
Jun 2, 2009
The function below only returns a true value for cells with a month value of September, but not those with December, March or June. Each cell in Row 1 contains a month. A1 = 9/1/2009. B= 10/1/2009 and so on.
View 2 Replies
View Related
May 24, 2013
I have created a excel file which stores attendance for my employees.
The format is like
Select month in one cell
select year in other cell
And from cell e8 to ai8 i have nos (1-31) represent no of days in a month:
a8 - 1
b8 - 2
c8 - 3
d8 - 4 like wise till ai8
Now I want a calender where user need to select the YEAR, and then MONTH and based on the above selection both days as well as date (not the month and year) should be displayed.
I am currently using this formula "=IF(ISERROR(--(COLUMNS($E8:$E$8) & "-"&$C$2)),"",COLUMNS($E8:$E$8))" for date and your vb code to hide the cells depending on days of months.
I need something like this
sun mon tue wed thur fri sat sun mon
1 2 3 4 5 6 7 8 9
View 3 Replies
View Related
Mar 19, 2009
I have a Workbook with a dropdownlist on it. The dropdown list has some names on it each name will be a refference to another sheet, ie when name Collins Jim is clicked on the drop down list the Jim Collins sheet will appear. I have attached a sample sheet to show you waht i mean.
View 4 Replies
View Related
Jan 19, 2010
I can create a drop list show various choices, is it possible to have the list of choice but also for the user to input text not in the list.
So if you had a list of names andrew, brian, chris and then not in the list you could write david ?
View 5 Replies
View Related
Dec 16, 2008
I have been asked to create a spreadsheet that will contain three fields;
Date of placement (the day the person arrived)
Date of release (the above + 60 days)
Billable days for the current month
The first is simple, the clerk will enter the current date when the person arrives.
For the second field I am using:: =SUM(H5+(60),) (H5 is todays date, and will display the results in I5). When H5 is blank, I get the " #VALUE!" error in I5? Is there a more effective function to use?
For billable days, I am using; =SUM(J2 - (H5),) (J2 is simply the last date of the month; 12/31/09, and H5 is the placement date). I want to show the number of billable days in the current month. This will be repeated on 12 sheets (one for each month).
View 10 Replies
View Related
Aug 12, 2013
I have a formula that returns me a result in hours. I have a result of 1712 hours but when i try and formatt the cell to show days is says 11. (Which obviosuly isnt right)
Is there anyway to show the correct number of days?
View 2 Replies
View Related
Jan 2, 2007
I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).
Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?
The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.
View 14 Replies
View Related
May 4, 2009
Hi guys i am in assistance of your brilliant brains, i have a working drop down menu which when selected i can select my data range such as below: ...
View 6 Replies
View Related
Aug 25, 2007
Can a macro be provided to show the list of sheet names in a drop down list at cell B2?
View 9 Replies
View Related
Jan 3, 2008
I have a list that I want to show in a drop down box. The list is like this;
MPK4
MPK4
MPK4
MPK4
MPK4
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
WK-7
WK-7
WK-7
WK-7
WK-7
WK-7
Can a drop down box be made to only show each item 1 time?
View 9 Replies
View Related
Dec 18, 2006
Im currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.
When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.
if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.
View 9 Replies
View Related
Apr 9, 2009
how i can fix the formula below to show the number of remaining days between the given date and the current date.
View 3 Replies
View Related
Nov 25, 2008
One sheet will be where someone will be able to select the filtering criteria from a drop down box (ie. Industry, Company, Location, etc) then click an execute button.
Then the macro will go to the second sheet where all the data is, filter the data and create a new spreadsheet with the selected data.
I have been able to create a filtering macro on the data sheet but have not been able to place the macro on the first sheet and have the macro run correctly. I have attached the file.
View 2 Replies
View Related
Feb 17, 2007
I have created a spreadsheet here at work to stream line certain orders. For memory Reasons, and sanity Reasons, it is one spread sheet for 5 different types of requests (moves, changes, cancel...etc). the top portion of this sheet has general info that is needed for all the requests...but then it is broken up to 5 sections, one for each request reason. there is a drop down list in the top general section to select your reason for request, so the group receiving the form doesnt have to do to much thinking and go straight to the section they need. but i want to know if there is some way to make it so if someone selects cancel in this drop down list, only the cancel section appears, and not the other 4 sections, or if they choose move, only the move section appears and so on...
View 9 Replies
View Related
Apr 16, 2009
I have several pre-configured macros that I would like to choose from using a drop-down menu. I know this is possible within the excel built-in ribbon, but I need to have it only in the spreadsheet. The macro will be importing a csv file. I have several different csv files that I need to be able to choose from and a drop-down list seems to be the best choice. The other option could be to have the macro prompt me to select the csv file of choice. Below is a sample of the macro that I would be using. Is this possible?
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;P:A Harvest of HealthImportVendorsA-N.txt", Destination:=Range( _
"$N$1"))
.Name = "A-N_7"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
View 9 Replies
View Related
Apr 21, 2009
i want to have an input box where i can select say 5 cities and have a chart of the weather in all those cities.
http://www.4shared.com/file/10050153...mpweather.html
is the excel file
View 9 Replies
View Related
Oct 2, 2009
I am new to writing macros and am wondering what is the easiest way to create a drop down and select multiple items separated by comas. The people who are going to input data into this spreadsheet are field people and not technically savvy so need to design something that is just a matter of cliking on the drop down and selecting multiple items and they should show on the same cell separated by commas.
View 9 Replies
View Related
May 10, 2006
I've created a budgeting spreadsheet and it is available to users via the web. When I initially created this I was short sighted and set everything as $'s. Users have limited ability to set formatting on this sheet.
I was wondering if I could create a drop down list for users to select their currency type which in turn would then drive the formatting used in the cells. I'm not quite sure how complicated this would be. Is this something that could only be done usa VB code? I'm pretty basic in Excel (know a good amount of formulas, etc).
View 3 Replies
View Related
Jan 2, 2009
I have created a color coded calendar on a spreadsheet for work that shows when a book will be published depending on when it comes into our warehouse, this is on sheet one.
I would like on sheet two to have some kind of filter or statement that would eliminate the need to look at the calendar, I.E. the user would just have to type in the date or select the date from a list and excel would show you what day the book would publish on using the data from sheet one.
I can imagine that this is hard to picture so i have attached the file as well.
View 13 Replies
View Related
Jan 14, 2009
If I have a dropdown with
A (value 1)
B (value 2)
C (value 3)
D (value 4)
and a person selects one of those letters in the dropdown in column 1, I would like column 2 to show the number value associated with it
View 14 Replies
View Related
Apr 1, 2009
I have the foollowing equation in a cell:
=NETWORKDAYS(A2,A12)+G12
My answer is 1081:23:42.
Is there a way to have it show the number of days, hours, minutes and seconds? So it will say 45:1:23:42? (45 days, 1 hour, etc...) Or something along these lines?
View 9 Replies
View Related
Aug 9, 2007
I have a spreadsheet that contains multiple rows per user. I need a combo or list box that pops up asking them to select their name from the drop down list. The list would be based on column A and would only include their name once.
When they select their name, the macro would then open the Form option from the Data menu, the Criteria button would be pushed and their name entered into the form, to return the first record their name appears on, then they could forward through the records, and update using the Next record button.
View 9 Replies
View Related
Dec 10, 2009
I am wanting to configure approx 100 drop down boxes to all point to the same range of data, approx 40 names, but once the name has been selected, none of the other drop down boxes will be able to select that name.
eg.
range:
Dave
Mike
John
Steve
select Dave in drop down box in cell B5. Next cell, B7, I want a drop down box without Dave in it.
If i then change my mind, and select Steve in cell B5, it will automatically adjust cell B7 to allow Dave as he is now no longer selected in cell B5.
View 9 Replies
View Related
Apr 17, 2007
I have created a drop down list but notice that the button (the arrow in the square) does not show up unless I click on the cell. Is there a way to show the button at all times so the user knows a drop down list is available?
View 9 Replies
View Related
May 6, 2007
I am creating a pivot table from region, which some of the rows are blank.
Is there any possibility that the pivot table not show the blank in its dropdown combobox?
View 4 Replies
View Related
Aug 5, 2009
I have set up a simple form in excel, whereby people use drop down menus to select the appropriate information (as all data inputted needs to be entered in exactly the same way to allow sorting, counting etc) so I thought drop downs were best. The trouble is the data is carried through to my excel database (on another worksheet) were it is shown in numeric values dependant on how far down the drop down list the select item appears (ie "Fareham" is third on the list, so shows in the database as "3").
I'd very much like my database to be easier to read and actually show Fareham etc, rather than be populated with lots of numbers. I initially tried using IF function (ie =IF(C3=3,"Fareham") but unfortunately two of my drop down lists are too long for this (with 25 and 33 entries respectively).
View 4 Replies
View Related
Mar 20, 2014
Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.
I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!
Attached File : Graphs.xlsx
View 10 Replies
View Related
Sep 29, 2010
I'm not including my spreadsheet because it has company information however, I will try to articulate my request as best I can. I currently have an Excel spreadsheet with about 20 worksheets, I would like to be able to click on the first worksheet, create a "Drop Down box" or "Data Validation" box or whatever I need to do to be able to view information in a range of cells on ANOTHER worksheet within the same workbook.
I've tried Data Validation, Drop Down Boxes, Define name ranges, all to NO avail. I'm missing a step somewhere, because I'm still not able to view the information on the first worksheet.
View 3 Replies
View Related
Nov 15, 2008
I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.
For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?
View 3 Replies
View Related
