How To Create A "notes" Drop Down
Sep 23, 2008
I have a sheet with 600+ rows(customers) and would like users to enter in new notes and be able to view old notes along with the date entered.
I am trying to create a page that will allow the user to enter in multiple notes in one row via some kind of drop down that will date the notes as they are entered. This way the user can click the drop down and see all the notes entered for that data set ect.
If this is not possible is there another solution? perhaps a referencing function that displays all prior notes and allows you to enter new notes dating each one?
View 9 Replies
ADVERTISEMENT
Jul 6, 2006
I would like to write a function that enhances conditional formatting capabilities in this way: suppose that cell(4,5) contains a number that can be 0 to 5
in the adiacent cell(4,6) i want to put a function that:
1) write "NO DATA", "HIGH", "GOOD", "MODERATE", "POOR", "BAD" depending on that value
2)Choose color font depending on value
3)Choose color background depending on value
I wrote this piece of
Public Function StatusResponse(AdiacentCell As Range) As String
Dim thisStatus As String
Dim ThisFontColor As Integer
Dim ThisbkColor As Integer
Select Case AdiacentCell.Cells(1, 1)
Case Is = 0
ThisbkColor = 2
ThisFontColor = 1
StatusResponse = "NO DATA"............
View 2 Replies
View Related
Jul 16, 2009
I have a a worksheet with a drop down menu in one column to show various completion status options (Not started, In progress and Completed). I was able to use conditional formatting to change the color of the cell to gray when I choose "completed" from the drop down menu, but I would like the whole row in view (about 8 cells across) to shade to gray when I choose "completed" from the drop down - not just the completed cell. I'm thinking an IF statement would work, but I don't know how to use an IF statement to shade a range of cells a color.
View 3 Replies
View Related
May 27, 2009
I have a column of cells with formulas that either return "" or some number. I want to create a named range that includes all values that have some number and not "". The problem is that the formulas in the cells are being included in my named range.
Dynamic Named Range: =OFFSET('!'!$B$7,0,0,COUNTA('!'!$B$7:$B$100000),1)
Problem: includes the cells that have been set as ""
I tried COUNTIF in the OFFSET where ">0" but it would get messed up when my first cells were set to "".
View 4 Replies
View Related
Jan 15, 2009
Can anyone tell me what the macro code is to do this (at whatever box I have selected at the time)
say my box is selected at E3, then when I click the button, it creates a new row E
likewise for F7, AA1, etc...
View 3 Replies
View Related
Jul 27, 2007
I have a little knowledge of Excel Programming and I am seeking advice and help. With reference to the http://www.exceltip.com/st/Create_Us...Excel/629.html, I managed to create the form but I somehow couldn’t get it executed. Attached herewith my file for evaluation.
View 14 Replies
View Related
Mar 22, 2009
I can't seem to find out how to use wildcards like "?" and "*" in the VBA- Replace("string","s*r","k") which should give "king"
View 3 Replies
View Related
Oct 15, 2009
This is a new question based on another thread that contains a solution that I want to tweak.
That thread implements a row that filters the rows below it based on its inputs. Basically, an 'equals' autofilter, but you can type in the criteria in the cells above the column headers instead of going into the autofilter itself.
Here's what I need:
As a variant on that thread, I would like to modify the code to filter on anything that CONTAINS the inputs (not equals).
For example, my Array is A6:K300, with row 6 being column headers, I want Row 5 to essentially be a filter terms row, where I can enter partial phrases in row 5 and have the columns directly beneath them autofilter if the phrase is contained in any of the array rows. If I enter '123' in a cell in row 5, I want the filter results to show '123' and '123R', etc.
View 4 Replies
View Related
Feb 10, 2009
In column A, I have the following values:
build
chil rat
datcen
mang
nextg
ost rat
omp
sco rat
In column B, I need the formula so it shows values that if column A = "build", "nextg" or "datcen", then the value in column B is "nextg" and if column A = "chil rat", "ost rat", "sco rat", then the value in column B is "mig". For everything else, it should be blank.
View 5 Replies
View Related
Jul 19, 2007
I have two worksheets, one with "supplier names", "order numbers" and "delay in days" as columns. The other one with "supplier names" and "average delays" as columns.
It is the column "average delays" that I have issues with, I need Excel to search the "supplier names" column in the "delays" sheet and identify every specific supplier name, connect the delay in days for that order and calculate the average delay in the right cell of the column "average delays" in the sheet "delay statistics".
I have tried the help files and to search this forum but I have found nothing. I have also with my knowledge tried a few different ways using the IF function but nothing so far.
This is something I started doing but it is of course far away from any truth.
=IF(;Delays!B1:B200="Greber")..............
This is the "delays" sheet where I want to find my info. Nothing in the delay column stands for "no delay"...Kinda obvious but you know... So even the "nothing" needs to be included in the calculation..
View 9 Replies
View Related
Nov 28, 2008
I need to prepare form which use to complete students' results for my teachers. Therefore,
I want to run a Macro which will do following things
1. Create new worksheets with the "template" and "template_2" into the workbook "Result"
2. It should bring the data from "Main"
a. From Third column C3 and create newworksheet name (for "template")
b. From Ninth column I3 and create newworksheet name (for "template_2")
c. bring data from D3 and put in the field of "template" (N6)
d. bring data from E3 and put in the field of "template" (D5)
e. bring data from F3 and put in the field of "template" (D6)
f. bring data from J3 and put in the field of "template_2" (O6)
g. bring data from K3 and put in the field of "template_2" (D5)
h. bring data from L3 and put in the field of "template_2" (D6)
I. It should rename the worksheet tab with Data from C3 and I3 (i.e. Class and Subject)
3. It should repeat the step 2 till it reaches the empty cell
View 9 Replies
View Related
Aug 28, 2009
I have a report I built on excel that is populated with data from an access database. The report pulls monthly stats per "sales group" I made one cell into a validated list that once I change it to another sales group, the entire sheet is updated with the values of the new selected group....
I have 40 or so groups, If I wanted to quickly print or view all 40 reports, how do i do that?
View 9 Replies
View Related
Dec 17, 2009
The following all is set to occur in Excel VBA (i.e. why it's not in Access forum)
I know of a way to create a database using a new ADOX catalog, BUT as there is a dedicated "CREATE DATABASE db_Name" SQL statement., I was wondering how you can execute a SQL statement (as you would to create a table) when there is no file to which you can connect yet.
I have searched for some manner of execute statement in ADOX, but all I can find is Create in the ADOX library.
I tried to connect to the prospective save folder location, but the error prompt indicates that the location is in use or it cannot be accessed.
View 9 Replies
View Related
Apr 16, 2009
tell me which operator works in VBA the way the OR operator works in functions? I want to write an IF statement that will evaluate whether a variable is equal to any of the three punctuation marks ".", "?", or "!". But I'm not sure how to code it. I attempted the following:
View 2 Replies
View Related
Jul 10, 2009
In my spreadsheet below I want to be able to enter a sales number for January, the value of cell F2.
I want cells F3 thru F12 to automatically calculate according to the "Growth Per Month" value in cell H1.
Example: If January sales are 20,000, then February should calculate to 21,000 (january * 105%).
Excel Jeanie HTMLSheet1
E F G H 1 2010 Per Month Sales XXX 5% 2 XXX XXX 3 February $ 10,000 4 March $ 5,000 XXX 5 April $ 2,500 6 May $ 1,250 7 June $ 625 8 July $ 313 9 XXX $ 156 10 September $ 78 XXX 11 October XXX 12 November $ 20 XXX 13 December $ 10 14 $ 39,990
Spreadsheet Formulas Cell Formula F3 =F2*10*H1 F4 =F3*10*H1 F5 =F4*10*H1 F6 =F5*10*H1 F7 =F6*10*H1 F8 =F7*10*H1 F9 =F8*10*H1 F10 =F9*10*H1 F11 =F10*10*H1 F12 =F11*10*H1 F13 =F12*10*H1 F14 =SUM(F2:F13)
View 9 Replies
View Related
Dec 20, 2008
As shown in the below image. I have some data from A13 to I 13. Currently if I put the cursor on A13 and press DELETE button then all the formatting from A13 to I13 goes off. But the data still remain there.
Is it possible then when I press DELETE the content of A13 then all the data from B13 to I13 should also get deleted ?
Excel Jeanie HTMLSheet2 *ABCDEFGHI13Key FieldEmp 11 2 4 8 5 3 7 Excel tables to the web >> Excel Jeanie HTML 4
View 9 Replies
View Related
Apr 29, 2009
i just tried the below formulae but its not working. if Currency in col A and Currency col B is same it should be "Matched" if not same the "CCY Mismatch" and if "#N/A Sec" then "Security Not Found"
View 3 Replies
View Related
Feb 24, 2009
I need to prevent users from entering several rows of data seperated by a "/" or a "," or a blank space ""
We use unique identifiers (around 500,000 of them) so I cant really use a drop down box to populate and then make the user select.....
If a user populates a cell with "10005486 / 10045446" or "10005486,10045446" I want to highlight a cell red and then count the instances of red cells on another tab so I can track "errors"
I was intending to use conditional formatting when a "/" or "," or " " is used within a cell. If a user makes this error, I should probably include a msgbox saying why the entry they have made is invalid also....
View 9 Replies
View Related
Oct 22, 2009
I'm having issues with sumproduct. I can't seem to get the right info that I need. Attached is the file I'm working on. Problem: I need to get the number of people "Occupied", "Partly Occupied" and "Available" on a Monday, Tuesday etc of the current week. "Occupied" means an employee has more than 2 tasks (based on New and Active-To-Date status). "Partly Occupied" means an employee is working on 2 tasks.
"Available" means an employee has NO task at all.
View 2 Replies
View Related
Nov 20, 2009
I have attached an example workbook to this message, with the sensitive data removed. I am trying to vlookup the "cube" for the product number, into the PO worksheet, IF the vendor numbers match.
Example:
On row 2 of the "PO" worksheet, part number AC1000110, should have a cube of 2.5 for vendor # 11170. I'm trying to match the "Vendor" on the "PO" worksheet with the "Vendor" on the "Cube File" worksheet, and then return the corresponding "Cube", (in column F of the "Cube File"), in cell U2 of the "PO" sheet. So, what formula needs to be entered in cell U2?
View 2 Replies
View Related
Feb 14, 2009
I am having problems referrring to a range using .Cells
If I try to use the remarked code (red text), it crashes with VBA "400" error for which I cannot find any explanation. It also crashes with same "400" message if I use a cells reference to a numeric column instead of "y").
The code works using the black it loops a column in Sheet("Holidays") and loops a row in Sheet("Schedule"), then color fills 2 ranges in columns in Sheet("Schedule") when the values in 2 cells are equal.
I have attached a scaled down version of my Workbook with this code.
View 2 Replies
View Related
May 26, 2009
creating a drop down box that will contain the names of all the worksheets in the workbook and on selecting a particular name it should go to the selected sheet.
View 9 Replies
View Related
Dec 11, 2008
I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.
View 14 Replies
View Related
Oct 25, 2007
I have a spreadsheet with the following headings:
A
Claims Number
B
Name
C
Scheme
D
Admin
E
Date
I need to create a user form that will "pop up" and ask the administrator to enter the above details.
A - should be created automatically (ie last claim number + 1)
B - user enters manually
C - data retrieved from a list
D - data retrieved from a list
E - date is the date the information is entered
View 9 Replies
View Related
Apr 18, 2006
I have two listboxes on a userform. One is the "choice" listbox, the other is the "master" listbox. Each item selected is a billing object on a sales invoice.
problem: The master list works fine when the item is selected in the choice list. But when it is deselected, how can you REMOVE it from the master list? question: How can I add a text box automatically to the userform to allow the user to enter quantity info?
For I = 0 To CodeList.ListCount - 1
If CodeList.Selected(I) = True Then
obj = CodeList.Column(0, I)
p = 6
test = 0
Do While test = 0 And p <= 25
If sheetsales. Range("C" & p) = obj Then
test = 1
Else
test = 0
End If
p = p + 1
Loop
If test = 0 Then.........................
View 2 Replies
View Related
May 19, 2009
I would like to create a list with reference to IF (E1:E150=1) list F1:F150
No Blanks. Cells E1:E150 will be either a 1 or a blank.
The new list will be created in cells Y5:Y whatever. List will then become a drop down list.
I have created the list but it has blanks between names and I just want the names....
View 9 Replies
View Related
Sep 13, 2006
is it possible to create a list of parts from a selection in one drop down box
ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.
ideally this list would start on another worksheet starting on row 10
View 6 Replies
View Related
Oct 19, 2006
I'm able to create a simple User form Drop-down list that references a cell range list. ( as a test for myself) I have 4 separate macros I would like to run individually. Rather than create 4 separate buttons, I'd like to be able to select each one via Drop-Down list.
View 4 Replies
View Related
Dec 2, 2009
I need "PC" to show up if I type a sentence containing "Called Parent", "Called Dad", or "Called Mon". Here is what I'm trying.
View 2 Replies
View Related
Mar 13, 2007
I have a procedure that processes data in a spreadsheet. It analyzes data in 365 sheets ( named "1" through "365") and creates a table/report with the results. When I run this on a scaled down version of my workbook (5 instead of 365 worksheets), the result is almost instantaneous. When this is on my normal workbook, the initial processing is about 1 second per day on Day 1, and the last day it speeds up to almost be instantaneous. It is not a linear relationship between the processing time (still working to get more exact timing information). Also, even if I limit my processing to 5 or 10 sheets, Days 1-10 are always slow and days 350-365 are always fast. The code being run is in the structure as shown below:
numSheets = 365
For counter = 1 To numSheets
x = CalculateSomething(counter)
Next
Private Function calculateSomething(counter As Integer) As Integer
Dim strCounter As String
strCounter = counter
With worksheets(strCounter)
For i = 0 To someNumber
For j = 0 To someDifferentNumber
'Data analyzed on worksheet
Next
Next
End With
End Function
The functions obviously aren't copied and pasted/functional, but the relevant efficiency stuff should be there.
View 5 Replies
View Related
