How To Use Date Field Within Spreadsheet To Notify
Mar 10, 2014
I have created a spread sheet, which automatically calculates 90 days in advance.
I would like to know how do I get the spread sheet to notify me, when the computer date reach's the 90 days date.
I have no idea about macro's or anything like that....
I would like an email to be sent to a couple of people if that is possible, i have attached the basic spread sheet incase its required to be viewed.
Property disposal2.xlsx
View 2 Replies
ADVERTISEMENT
Sep 9, 2008
way to be able to send an email notification 30 days before the contract expires.
I have attached a sample list. Is there anyway of doing this using a macro or through VBA?
View 12 Replies
View Related
Jul 4, 2013
In the following extract, I would like to have today's date placed into Col K when an entry is made into Col J.
Entry into Col J is from a validation list of 3 options. What I desire is that when one of these options is selected ("Complete"), then I would like today's date to be written into Col K.
Currently Col K has a validation list which comprises dates from 1st of each month from July to June.
I need a fixed date as text preferably, so was thinking the VBA function "Date" on a Change Workbook Sub.
The information is currently part of a Table in Excel 2007 that has about 500 records.
IdeasList
*
J
K
2
Status
Month Completed
3
In Progress
*
4
Complete
Jul-13
5
*
*
6
*
*
Data Validation in Spreadsheet
Cell
Allow
Datas
Input 1
Input 2
J4
List
*
=ValidationList_Status
*
K4
List
*
=ValidationList_Months
*
View 2 Replies
View Related
Dec 28, 2006
in coverting these fields into a date field.
Example 91306 to 060913
I have encloed the file.
View 14 Replies
View Related
Apr 29, 2006
I am trying to count the number of times that data is in a field and in any field the date is greaert than today's date. This date field could be blank and that is where I am having the problem.
Example
See Attached
View 4 Replies
View Related
Aug 25, 2007
I have a spreadsheet where I keep track of sales that I make in ebay. The spreadsheet has the following columns: Name, Product, Prod Cost, Shipping Cost, Payment Received, Total. I have made a list way off the the right of the spreadsheet with all the products that I sell, so in the "Product" column I can use a pulldown menu and choose the item from the list. However, I was wondering if I could create it in such a way that when I chose the item from the list, it would automatically put the cost in the "Product Cost" field. Is this possible?
View 9 Replies
View Related
Mar 31, 2014
I have a spreadsheet of over 8000 addresses. I have the street, state and zip but not the cities.
Is there a way I can do a search and mass import of cities from a website, like USPS? I'd like to know if there is something I can do quickly rather than manually look each zip code up and enter it in one by one.
View 2 Replies
View Related
Feb 10, 2009
I am trying to do a query against my database using MsQuery, but I am having a problem with it...
One of the tables in my database stores information as Binary (Bits) instead of actual text.... When I create the Query in MsQuery, the text is displayed as desired...but when I send it to Excel that column is not displayed..
Does anyone have any ideas on how I can get it to send the column to Excel?
See attached for what I mean. The Bits column shows in MSQuery, but not in Excel.
View 14 Replies
View Related
Nov 27, 2013
we have a large document that many times has the autofilter engaged (so that it has to be cleared to see all the rows). I know you can click on the top of the column to undo and that it changes the icon slightly when there is is a filter applied...
but with my bad eyes and the MANY columns across (so they are very small - and no I can't make the bigger bc I need to be able to see them all) sometimes I don't see the difference between the normal arrow and the filterd arrow.
Is there a way to do some kind of conditional formatting (say on Row 1, that is frozen at the top) that would so that the cells could turn a different color if there r any filters on that need to be cleared?
kind of quick very easy to see and bright notice of - "someone put a filter on, you might want to clear it before looking order number
View 1 Replies
View Related
May 13, 2014
Dbod_BUDGET_TEMPLATE_NEW_test popup.xlsmHi,
I have created a budget template. In some instances, a discount is offered when more that x amount of products are ordered ( it varies,so I'll have to change the macro for each instance). I'd like to have a pop up box appear ( and dissapear again when pressing 'enter') that gives a notification like: a discount is applicable, select'
my cell with entered amount is "I54", and want a message if entered above 5
I tried the below and swapped places between sentence 1 and two as it doesn't seem to recognize subname, or sub start, or it just dissapears from my macro list ( although still a module): ( in the below order, it stated it expects the sub to end after sentence 1, if i remove sub popup () ( the title) ut just deletes the thing from my macro lsit,w hat is goign on!, and it just wont work)
'Sub popup()
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
[Code]....
View 1 Replies
View Related
Aug 7, 2014
Look at the attachment below. I would like to compare two data sets;
DCLG Codes and our internal codes (all highlighted in the colour peach).
One or more of our codes can 'feed into' our parent organizations codes. Please see the Summary sheet and it will become apparent.
At the moment, I have been able to remove the duplicates from the DCLG codes and then 'marry them up' using a SUMIF function to add up all our ledger types- according to their codes.
Basically, the bottom line is that all our spending or income (The ledger Types) has to be grouped (if more than one) and reported back into their system codes.
Here's the more, possibly challenging bit....
Our system generates the ledger types and the monthly spend and year to date every month. from time to time, different ledger types may be added to the table (this will always be from our end).
We would like a way to copy and paste this data next to their table without throwing out the tables or distorting the codes that they relate to on a permanent basis.
My question/s is;
Is there a way to match and validate the data and put in an alert to notify us of the error? And then when we are happy, we could carry on as normal and generate the SUMMARY sheet.
I know of the data validation method and looking for an exact match but I was wondering if the corresponding figures would be affected in anyway.
What may be good would be to have a data dump/input area where the data is matched possibly via a VLOOKUP and anything that is not matched is displayed at the bottom of the list?
The results do not necessarily have to be like what I've suggested above. all I would like to be able to do is match the data first (and their corresponding figures) and output according to their codes. I need to be able to identify new or unmatched Ledger types.
And a report : DCLG Workbook Template Master.xlsx
View 4 Replies
View Related
Jun 14, 2014
I use the vba to open excel file. like workbooks.open filename:=abc.xlsm but I found that if the file is opened by other. Excel still open the file but it will not notify user that it is opened as read only.
Would you add more line to notify user if the file is opened by other?
View 2 Replies
View Related
Dec 10, 2009
The code below returns sytax error. How do I fix that and how do I simplify and compress code? Private Sub CommandButton1_Click()
View 5 Replies
View Related
Apr 13, 2009
I need VBA code to sort the birthdays for all the employees in my company.
See the attached file for example.
I need to sort according to their month and then date and not with their year.
i.e it should not consider Year for sorting.
View 2 Replies
View Related
Jun 28, 2007
How can I add a date stamp that will populate a field when text is entered into another cell but will not change every time I re-open the sheet. I have been using =if(B4="",NOW()) which changes each time though and as soon as text is entered it disappears. I want to capture the actual date that someone enters text into a cell and save that date in another cell???
View 5 Replies
View Related
Aug 4, 2009
I want column S to show today's date if any cell is modified within that row.
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row, 19).Value = Int(Date)
End Sub
and it works, I get today's date in that row. But when I do a test on the date, (=ISNUMBER) I get false which means I can't check that date with a macro.
View 9 Replies
View Related
Sep 15, 2014
Once i identify the PivotField, how can i filter it to be > than Date?
View 2 Replies
View Related
Jun 18, 2014
I have a pivot table with a field called "created on" which is a series of dates, i want to create a field called "Days in Pipeline" which would essentially be =TODAY()-'Created On'
This doesn't seem to work, i get an error: Your formula includes a function that cannot be used in PivotTable formulas...
View 1 Replies
View Related
Apr 7, 2014
I'm trying to update an excel document which has a list of employees on it along with their training. Most of the training for individuals needs refreshed in the next year so wanted the table to use the date and perhaps trigger a fill colour change once they are close to needing that training. here's an example
John Smith
course 1
Completed 01/05/10
Refresher required 01/05/14
Once we get a month or two before the required date, I would like the fill colour to change to highlight that they refresher training should be organised soon.
View 6 Replies
View Related
Nov 7, 2008
I want Cell B1 to display the MM/DD/YYYY of when Cell A1 was updated.
so when I update A1, B1 is automatically updated with today's date.
Is this possible?
View 8 Replies
View Related
Jun 5, 2009
What i need is to be able to concatenate a field such that it includes current system year,month,day and time. My attached spreadsheet illustrates my current formatting to achieve year,month,day. But I seem to be challenged in getting the current time to display properly.
View 4 Replies
View Related
Dec 8, 2011
I have a list of dates with an hour inside them . I am trying to remove teh hour from the field , and leave only the date. teh format option just hide teh hour but not removing it how can it be done ?
View 4 Replies
View Related
Mar 19, 2013
I want to display a date and time in local time, is there a simple formula to do this?
View 3 Replies
View Related
Aug 12, 2009
I need to complete the 'cost field' in Table A, from Table B, but the 'cost' value must be selected from Table B based on it's ' date completed', as per my example attached...
View 9 Replies
View Related
Mar 26, 2014
I have a couple of columns, once edited need to update a table in SQL. This is my code
[Code] .....
However it is not taking UK date formats, it is assuming it is an american format, I get conversion of varchar data type to datetime results in an out-of-range value. What should I add to change the format? The format is in UK on the spreadsheet seemingly....
View 11 Replies
View Related
Nov 7, 2013
I need to extract a month from a field which looks to me like a date field, but as you can see in the file: Month(A1) returns 11/01/1900 instead of 06/11/2013.
View 4 Replies
View Related
Aug 26, 2009
I have a file, a portion is attached, where I want to paste the value of the formula (in this case, just that of the external data) once it has grabbed the data from an external source.
If the first time I open the file is Jan 15, I want it to grab the data in columns C, E and G from Jan 1 to Jan 14 and paste each cell's value in the same cell. Any data on Jan 15 or past Jan 15, I don't want the value (hasn't been collected yet).
If I open the file again on Jan 18, I need the data from Jan 15 to Jan 17.
I have this macro which works well for grabbing the data and pasting the value.
View 3 Replies
View Related
Mar 18, 2012
I have a date field 08/09/2011 and want to monitor an item to ensure it's "Approved" before it reaches this date.
The groups are:
Late = this date or past
Within 1 week
Within 2 weeks
Within 3 weeks
Over 3 weeks
How to do this, I tried Nested, and I've tried lookup but I'm not sure how to tackle it.
View 5 Replies
View Related
Nov 21, 2006
I have a column formatted as a date. I would like to filter out all rows which have a blank date value. I don't see any blank value to select when I try to select auto-filter for that row. Any suggestions?
I would like to filter out the blank values because I found that if I pivot on the data and there are blank values in the field, I can not use the group option for that field.
View 9 Replies
View Related
Feb 6, 2009
I need to have a cell with a date in it then the next cell needs a formula to caluclate how many days it has been since that date???? I'm a real novice with excel.
View 9 Replies
View Related
