# Search:

Type: Posts; User: MrHydrant1857; Keyword(s):

1. ## Thread: Matchmatical Formula in Cell based on a selection from a dropdown

by MrHydrant1857
Replies
0
Views
90

### Matchmatical Formula in Cell based on a selection from a dropdown

Hi all,
I have an excel sheet that has a dropdown with different selections (Products) in it and based on that selection a certain cell generates a preset number from a table. I have then another...
2. ## Thread: Excel Day(Date) / add number to a cell based off Day(Date)

by MrHydrant1857
Replies
7
Views
230

### Re: Excel Day(Date) / add number to a cell based off Day(Date)

got it! thanks so much Rick!!!
3. ## Thread: Excel Day(Date) / add number to a cell based off Day(Date)

by MrHydrant1857
Replies
7
Views
230

### Re: Excel Day(Date) / add number to a cell based off Day(Date)

also what if i were to have the days of the month start in column B instead of A?
4. ## Thread: Excel Day(Date) / add number to a cell based off Day(Date)

by MrHydrant1857
Replies
7
Views
230

### Re: Excel Day(Date) / add number to a cell based off Day(Date)

ok so if the sheet where my Days of the month are (1-31) is named Tally then the code would look something like this?

Sheets("Tally").Cells(2, Day(Now)) = Sheets("Tally").Cells( 2, Day(Now)) + 1
5. ## Thread: Excel Day(Date) / add number to a cell based off Day(Date)

by MrHydrant1857
Replies
7
Views
230

### Re: Excel Day(Date) / add number to a cell based off Day(Date)

Rick,

My apologies I am pretty tied up at the moment and just wanted to put something quick out there to see if anyone could help. I do see how my description is not clear. anyways,

1).Yes my...
6. ## Thread: Excel Day(Date) / add number to a cell based off Day(Date)

by MrHydrant1857
Replies
7
Views
230

### Excel Day(Date) / add number to a cell based off Day(Date)

I have a sheet that i have columns numbered 1-31 (Days of the month). i have another sheet that has a cell with a Today() formula. when i activate the macro i want to get the day of the month from...

by MrHydrant1857
Replies
1
Views
118

### Excel "Database"

Ok i have asked this question already before but i have gotten no where. I have simple standard cell that i enter a Name, Company, City/State, phone, and email. I would like for that information to...
8. ## Thread: Compile Error: cant find library or folder (DATE) in VBA

by MrHydrant1857
Replies
7
Views
266

### Re: Compile Error: cant find library or folder (DATE) in VBA

what I meant by that was, the computer I am having the compile error is not letting me view the references. under tools the references is just grayed out so I cannot see what references are missing...
9. ## Thread: Compile Error: cant find library or folder (DATE) in VBA

by MrHydrant1857
Replies
7
Views
266

### Re: Compile Error: cant find library or folder (DATE) in VBA

i believe the excel where this program was created intitially is in Office 365 and doesnt really give a year. looks like 13 or 16. the excel where its not working is 2010. i am certain that the vba...
10. ## Thread: Compile Error: cant find library or folder (DATE) in VBA

by MrHydrant1857
Replies
7
Views
266

### Re: Compile Error: cant find library or folder (DATE) in VBA

the problem with the computer it is not working on will not let me select references. it is not highlighted. any reason that may be?
11. ## Thread: Compile Error: cant find library or folder (DATE) in VBA

by MrHydrant1857
Replies
7
Views
266

### Compile Error: cant find library or folder (DATE) in VBA

I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to...
12. ## Thread: Excel Autofill contact info from previous times entered in

by MrHydrant1857
Replies
2
Views
119

### Re: Excel Autofill contact info from previous times entered in

yes thats what i was already thinking of doing but i was concerned with the way my sheet is set up that i wouldnt be able to add new contacts or i would have to pre add contacts to the new sheet.
13. ## Thread: Excel Autofill contact info from previous times entered in

by MrHydrant1857
Replies
2
Views
119

### Excel Autofill contact info from previous times entered in

I have a "Form" that I input a customers contact info in such as Name, company, city/state, phone, email. I would like excel to remember the name I typed in and when I go to type that name in again...