Over 1 million tech questions and answers.

Can Excel Automatically Update My Date Fields?

Q: Can Excel Automatically Update My Date Fields?

Hi people! I'm new to this forum, and have not been looking around much, but will from now on. While i'm a computer technician, Excel was never a strong point - i was always more of a 'hardware' guy. In any event, i have a question that needs some answering. Bear with me if some of my terminology is not %100 correct. I'll try my best.

I have a 3-page spreadsheet. On the 1st page, i have the values I input. Column A(A5 and down) is the date column. B - S are the numerical monetary values I put in, and T & U are the totals. One is a numerical total, the other a monetary total. On the 2nd page, Column A is again dates(B is reserved for manual input), and C & D are the row totals from the 1st page. I manually input data from E - M, and Column N is =SUM(B2:M2). You get the picture.

Here's where it gets tough. The 3rd page is just a break down of the monetray charges for any given day. What i want is for the 3rd page to update the date on the top to the day it is now, and then the monetray totals for that day only, or the day before, whichever I need. I guess What i want is if I change the date on the top of the spreadsheet page, it will update the totals in each of the cells i have underneath. It's not going to be printed, just for viewing on my screen. Right now, I have to input the data for a daily printout manually. If i can change the date at random, and get it to update the totals from the other page, that would be great.

That being said, i thought about using the =TODAY() or =NOW() functions, but i'm not sure how. i'll gladly send along a blank copy if someone needs it. Thank you in advance for your help.

ron schwarzmer

RELEVANCY SCORE 200
Preferred Solution: Can Excel Automatically Update My Date Fields?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Can Excel Automatically Update My Date Fields?

Read other 16 answers
RELEVANCY SCORE 78

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Professional , Service Pack 1, 32 bit
Processor: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz, x64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2993 Mb
Graphics Card: Intel(R) HD Graphics, 1272 Mb
Hard Drives: C: Total - 234274 MB, Free - 193142 MB; E: Total - 2048 MB, Free - 2010 MB;
Motherboard: Hewlett-Packard, 1722, KBC Version 29.36, CND037022T
Antivirus: McAfee VirusScan Enterprise, Updated and Enabled

I would like to add a formula that would automatically calculate a date field from one cell and add three years. See example attached, Thanks in advanced
 

A:Solved: Calculating Date Fields in Excel

Read other 7 answers
RELEVANCY SCORE 70.8

Is it possible to create a formula in excel to convert a date to another date based upon conditions? I need it to convert any date in a column of cells that is not the first day of the month (MM/01/YYYY) to one month prior on the first day of the month (MM-1/01/YYYY). Can this be done with a formula?

Thank you. Working in Excel 2003, XP OS.
 

A:Get Excel to change a date automatically

try this
=DATE(YEAR(C2),MONTH(C2)-1,1)
where C2 is the cell with the date you want to change
 

Read other 2 answers
RELEVANCY SCORE 70

Hi,

I've noticed some similar queries on here and wondered if you could help me with a task i'm trying to achieve.

The attached spreadsheet is based on one I found elsewhere on the internet, and when a cell in the B column has a value above 200 it generates an e-mail based on the data. I've shown it in working form at the top of the sheet, and underneath is a test set of data for what i'm trying (and failing!).

What i'd like to do is change it so that rather than MyLimit = 200 (As it seems to be listed in the Macro/sheet view), it's triggered by any cells in Column C with a date on or before the date the spreadsheet is opened. When this happens i'd like it to say 'Sent' or 'Not Sent' as it does at the top of the page, but in Column D instead (I couldn't work out how to transfer it.

Lastly, when the e-mail is triggered it currently says:

"Hi Tom
The following client has now entered their expiration as of the stated date : 220
Regards,
Jake"

Whearas i'd like the expiry date from Column C placed in there, as well as the Client name just after "The following client, "

I've tried to edit it but so far had no luck, apologies for the lengthy message but hopefully these problems are quite easy to fix, any help greatly appreciated!

Thanks,

Jake

p.s. The next step is to work out how to get this spreadsheet to open automatically every day but I think that's a task for a rainy day... Read more

A:Excel - E-mail automatically sent depending on date?

Read other 6 answers
RELEVANCY SCORE 70

Hi, I am hoping for some to help with a spreadsheet I am creating for work. I have a drop down box set up in G2 when "Yes" is selected from this it stamps the date in the cell next to it (H2) this signals when a task was completed. The code I have currently got in H2 is
Code:
=IF(G2="yes", TEXT((DateStamp),"dd/mm/yy" ),"")
"DateStamp" is defined as
Code:
=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
This is found in the name manager (ctrl+F3)

The problem I am having is that the day updates each day. So for example if I completed a task and marked it "Yes" today (01/02/11), and re-opened the task tomorrow (02/02/11) it would read as the 2nd Feb rather than the 1st. How do I get it to remember the day that the task was completed rather than today?

Thanks in advance for any help with this.
 

A:Excel 2007: Recording a date automatically

Read other 7 answers
RELEVANCY SCORE 69.2

I have an excel spreadsheet with lots of dates on it. One time, I saw someone create an arrow or bar that automatically went to today's date on the spreadsheet, so a person would not have to scroll down through past dates to get to today's date. I tried to " create a new rule" in conditional formatting so that today's date was highlighted yellow. The highlighting feature works, but when I open the spreadsheet I am not taken automatically to today's date. Is that some other feature? Can it be done on the excel in google drive?
 

A:Go to today's date automatically in Excel in Google Drive

Hi,

I'm not sure about the "Conditional formating". But, You can have a code in the "Thisworkbook module" that will go to today's date.
 

Read other 1 answers
RELEVANCY SCORE 69.2

I have a time sheet that won't change any fields. The month has a dropdown box to select the current month. Selecting a different month (say June instead of May) doesn't change the day and mm/dd. Changing start or end time doesn't update the HOURS.
If I manually change every formuls in the sheet, the caclulations work.
ANY suggestions what the problem could be?

May, 2008

Day Date From To Code Hours
Tue 04/01 6:00 AM 6:00 PM S 12.0
Wed 04/02 6:00 AM 6:00 PM S 12.0
Thu 04/03 5:30 AM 6:30 PM S 13.0
Fri 04/04 5:00 AM 11:00 AM S 6.0
 

A:Excel 2007 won't update fields

Hi there, welcome to the board!

It really sounds like your sheet calculation state is in manual calculation. Check the state and put it in automatic. Or try the keyboard shortcuts (Ctrl + Alt + Shift + F9, which will do a full workbook recalculate and restructure the dependencies list, or just Shift + F9 will recalc the current sheet).
 

Read other 1 answers
RELEVANCY SCORE 67.6

Hi All!

I am having major difficulty figuring out excel. I am using a spreadsheet and want excel to automatically send an email to the user in that row when a contract is expiring. Within the row I have the specified user's email, the end date of the contract, and when the reminder email should go out. I have tried playing around with Macros and VBA coding, but I have no idea what I am doing. I am using excel 2003. Any help would be greatly appreciated!! I am using Outlook as my email. Have questions please let me know!

-J
 

A:Email automatically sending to user when cell is at a certain Date Excel 2003

Read other 16 answers
RELEVANCY SCORE 67.6

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

A:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

Read other 3 answers
RELEVANCY SCORE 66.8

About early December 2006, my Dell Inspiron 2200 lap top computer began failing to change the date daily. I have had to manually change the time and date whenever I turn on my computer. I've gotten all the Windows XP updates, I've done all the Dell updates, but that hasn't fixed my problem. Please help me! Thanks!
 

A:Time & Date does not automatically update

You probably need a new battery that is located on the Motherboard,very inexpensive and easy enough to fit ....se also this site http://www.velocityreviews.com/forums/t308958-clock-not-keeping-time.html
 

Read other 1 answers
RELEVANCY SCORE 65.6

I need the date to appear as todays date whenever a file is opened. So today if I were to open a letter file I need the date to already appear as todays date without having to input any text. Does anyone know how to do this. I have taken the manuals out from the library and am getting no help that route. Thanks very much in advance!!!!
 

A:Word 2003 how to make the date automatically update

"Insert">>"Date and Time" and check off "Update Automatically" within the dialog box that pops up.
 

Read other 1 answers
RELEVANCY SCORE 63.2

This should be simple enough . . .

I have a column of numbers that I would like to increase in value by 1 every Sept. 1. I could easily cut and paste or find and replace on Sept. 1, but I'd prefer to use a formula so that the update is done automatically. Any ideas?
 

A:Excel: update value by date

Read other 9 answers
RELEVANCY SCORE 62.8

"Error Message: Error 501/505: Not Implemented or Not Supported" This is the err msg I get when trying to connect to any HTTPS. KB Article ID : 811262 did not help: now it returns just a blank page without error message, but it goes to the site. That's progress?Went through tutorial "Internet Explorer Cannot Connect to Secure Web Sites" without luck. Just get quick black box image at Start/Run fix "sfc/scannow" with nothing else returned. ?Can't update Date/time, even though my time is correct to day and minute. Get a simple "an error occurred when," except a few times I got "time sample rejected because peer's stratum is less than host's stratum." ???Internet Explorer 7, Win XP Pro, Thinkpad, generic router, cableOur LAN is forced to function out of a specific address; we can't reset it to "Automatically detect LAN settings" or rather it resets itself to "Use automatic configuration script: [url="http://localhost:9100/proxy.pac""]http://localhost:9100/proxy.pac"[/url] every time. We have no proxy enabled, and dial-up is set to "Never dial."I can't think of anything new that was added prior to this, except I gave Microsoft the run of my machine from a distance. That's the only way I can explain that LAN setting.I have been to the secure sites I am trying to access many times. It started to get a little rambunctious last week or so, but I added the site to Trusted Sites as I recall and h... Read more

A:Can't Reach Https; Can't Update Date/time; Can't Use "automatically Detect Lan Settings" Option In Connecti...

Hi swabbity,Try this:Close all running programsClick Start/ Run/ Type in cmd/ Click Okay.In the window that opens, type in regsvr32 actxprxy.dll (note the space between 32 and actxprxy). Hit Enter.Now type in regsvr32 urlmon.dll (note the space between 32 and urlmon) Hit Enter.Type in exit and hit Enter again.Now open Internet Explorer, and try opening some links.If no luck, see if this helps: No LinksLook under, "If you get a blank page"

Read other 3 answers
RELEVANCY SCORE 62.4

I have a spreadsheat that I periodically update, and in the lower left hand corner I manually type the date that the information is updated. Is there a macro or such that will automatically update the date when the spreadhseat is opened?
 

A:Auto update the date in Excel

Do you want the macro to change the date when the workbook is opened or everytime it is saved?

There are two events you can choose from to place the macro. Both events are in the workbook Module. With the Workbook open, press ALT + F11 to bring up the Visual Basic editor. On the left side of the editor window you will see your project explorer. Find the item called ThisWorkbook and double click it. This will bring up a blank workbook module. Just copy and paste either of the two code modules below. Just change the destination location of the date which I have made "A33" in the code. The first code is for the Before_Save event and the second is for the Workbook_Open event.
Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A33").value = Date
End Sub
or

Code:

Private Sub Workbook_Open()
Range("A33").value = Date

End Sub

Rollin
 

Read other 2 answers
RELEVANCY SCORE 61.2

Hello,

I have worksheet that is used to track progress on work tasks. I have some VBA that adds information to separate log worksheet when the estimated completion dates are changed and show the variance between the planned date and the new expected date.

What i'd like to do is provide a summary that gives a snapshot of where the task is currently. For example over a period of time a task may have had its expected complete date changed several times, what I want to display is the last change and the current variance to plan.

Task Plan Actual Variance Changed
1 09/07/11 09/10/11 3 08/01/11
1 09/07/11 09/15/11 8 08/08/11
1 09/07/11 09/09/11 2 08/15/11

Any help will be greatly appreciated
 

Read other answers
RELEVANCY SCORE 59.2

Hello everyone:

We are trying to build an update query in excel to update one date in b2 to the date that is a h2. However instead of returning a date it returns random numbers.

Any ideas?
 

A:Solved: Building Update SQL Query in Excel Return Wrong Date Format

Read other 6 answers
RELEVANCY SCORE 59.2

Is it possible to link an Excel and a Word file so that a change in Excel would automatically occur in Word?

I have a membership roster in Excel and I'd like to have a mailing label file that would automatically be changed when I add or delete names in the Excel roster. (Going through the whole mail merge process is cumbersome.)

I've tried searching the Help files, but it refers to embedded objects and such and I don't think that's the way to go with this.

Thanks for any help!!!
 

A:Solved. Linking Excel list to automatically update Word

Read other 8 answers
RELEVANCY SCORE 58

Hello, I use online accounting software (KashFlow) and part of entering invoices involves clicking into a date input field.  It is one of those where a little calendar shows when you click into the field.  You can also manually type a date into this field too. However. On my brand new Yoga 920 using Chrome and Firefox the date input fields are greyed out and a red 'no access' icon shows when you hover over them.  But you can still click it and the calendar pops up as normal.  The only difference is you can NOT type into them anymore. When the source for the page is viewed it looks like the fields have been designated 'readonly'. There is no such problem on any other computer I own, even when using Chrome or Firefox.  The date fields work perfectly well on these other computers - even on a Sony Xperia tablet I own. The only browser that works properly on my Yoga is Edge.  The date fields work as they should.  It's just Chrome (my main browser) and Firefox where they don't work. This seems like a Lenovo-based problem.  A little Google has revealed a couple of similar problems with other Lenovo users. Does anyone have any clue on how to fix this?  This is utterly bizarre behaviour and it's preventing me from working properly. I have attached a photo showing the problem when using Chrome.  These fields should never be greyed out. Thanks,Matt







... Read more

Read other answers
RELEVANCY SCORE 58

I have created a form in Word using text fields. I would like the fields to automatically update, for instance, when I type the persons name in, I would like their name to appear in two other places without having to right click and 'update field' each time. Is there a way to do this?

>>Okay so I found a few options on my own. One being a field called "link". But I have to "link" each one that I want to update which just seems silly....

am I missing an easy fix here? Someone?
 

Read other answers
RELEVANCY SCORE 57.6

I have been trying to help a friend learn how to do form letters with his Microsoft Works Suite 2004 programs. He has Windows XP SP2. We were able to successfully merge desired fields from a Works database but noticed that the format of date and time field results was not as desired. The date field always merged as "MM/DD/YYYY" in the form letter no matter what format was used for date display in the database program. He wanted to display, for example, "November 12, 2004" instead of "11/12/2004". Likewise, the time field merged as "hh:mm:ss AM/PM" when he wanted, for example, "11:25 PM" to display.
In Works 4.5 (on another computer), his formatting carried over to the form letter from the database. Not so in the 2004 version. Our temporary fix, was to format the date & time fields in the database as "text" instead of "date" or "time" and then enter the exact display style wanted. Then, the merged value looked the same in the letter as it did in the database.
Is there a better solution to this problem?
 

Read other answers
RELEVANCY SCORE 57.6

Friends, I have a subform with two fields yes / no. How do you select only one field to yes?
That is, if the "A" is set to yes, you can not mark the field "B" to yes, this example is only possible
mark the field "B" to yes, after clearing the field "A".

And the reverse, ie, if the "B" is marked
and yes, you can not mark the field "A" to yes, this example is only possible
mark the field "A" after clearing the field "B".

I tried this two codes:

Private Sub Form_Current()

If Me.FieldA = -1 Then
Me.FieldB.Locked = True
End If

If Me.FieldB = -1 Then
Me.FieldA.Locked = True
End If

End Sub

Private Sub Form_Current()

If Me.FieldA = -1 Then
Me.FieldB = 0
End If

If Me.FieldB = -1 Then
Me.FieldA = 0
End If

End Sub
In the first works only with the first two records, the third record from the two fields are locked.

In the second code has no effect.

Thanks for helping.
 

A:Solved: fields switch yes / no automatically

Read other 15 answers
RELEVANCY SCORE 56.4

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

A:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

Read other 16 answers
RELEVANCY SCORE 56.4

Hi there,
I have an MS Access database (2000, but primarily operating on PC with Access 2010). The database logs wagons coming to and from our site. Mostly, these wagons are in and out in the same day, but it is possible for them to park up overnight, for which we charge a small fee.

The situation has now changed slightly, in that we now accept wagons staying on site for longer periods (usually a weekend), so I've been asked to introduce an Exit Date field as well, and correct the existing calcualtion of time on spent site.

Currently, the following fields appear in the main table (called Stays):

Arrival Date
Arrival Time
Exit Time

There is also a field called Duration, which (for some reason) is autofilled by an Update Query, with the Update To value set to:

IIF([Arrival Time]>[Exit Time],1440+DateDiff("n",[Arrival Time],[Exit Time]),DateDiff("n",[Arrival Time],[Exit Time]))​

This is clearly inaccurate - it assumes that if a wagon's exit time is earlier in the day than its arrival time, then it must have stayed for 1440 minutes + the (negative) difference between the two times, and if the exit time is later or equal to the arrival time, the wagons has been in and out of site in the same day.

As wagons could be on site for multiple days (so the 1440 mins figure could be wrong) and could leave x amount of days plus x amount of minutes after arriving (so the assumption that it's exited the same day as it arrived could be wrong),... Read more

A:Solved: MS Access modifying a date and time calc in separate fields

Read other 8 answers
RELEVANCY SCORE 56.4

EXCEL SOS!!! I have an urgent deadline which I'm likely to fail if I can't get my head around this issue so please please feel free to comment / offer suggestions...I'll try anything!

I have around 10 - 15 sheets within the same excle file which is effectively acting as one tab per resource within my consultancy team. These are acting a a record of the billable & non billable hours per resource and therefore each line is primarily driven by date (2011 - 2013), with 1:N ratio items of the following: Client, Contract, Role, Days & hrs (effectively 1 line per date, resource, client & contract combination + time billed within the std 8 hr working day).

I have no problems creating individual pivot tables in the individual resource name's relevant tab, however the next step is to roll this information togather to show a holistic view for all resources, all clients etc (in what I anticipated to be a pivot table via the consolidation of multiple ranges function) for all resources by exactly the same fields:

Year, Date, Contract/Type, Resource, & Date - at row level (with possible additional options of Month, Week, Day being added as a row label)

AND

CLIENT , Non Billable - at column level

Naturally there may well be some slicing and dicing of the info needed to understand the figures at different levels, ie per resource (days billed & rate), how many hours used per contract, how we've used time in a contract (by role), & whom (by... Read more

A:Solved: Pivot multiple sheets for text, date and decimal fields

Hi there, welcome to the board!

I feel your frustration. Unfortunately your data structure isn't conducive for a PivotTable data model. But there is hope! You have some options here. First of all we need to know what version you're using. If you have 2010, well, you're going to really like what I'm about to tell you, and if you don't have it, it's a good reason to upgrade! 2010 has a new add-in called PowerPivot. Think of it as PivotTable's on bulk steroids. The benefit you would see - the ability to select multiple data sources. This means you can have multiple data tables/sheets as your data source, and select their relationships. Think of it like an Access table/relationship. It's the best feature we've seen in Excel since the PivotTable itself.

So if you have 2010, this is good news. However, if you don't have 2010, we need to consolidate your data to a single data structure. Whether that is putting it all on one sheet, or exporting to Access, or whatever, that's what needs to happen.

I'm not entirely sure what you mean about not getting the row level structure. Is there any way you can post the file?
 

Read other 2 answers
RELEVANCY SCORE 56.4

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

A:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

Read other 1 answers
RELEVANCY SCORE 56

Logfile of Trend Micro HijackThis v2.0.2Scan saved at 10:34:58 PM, on 1/17/2008Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Boot mode: NormalRunning processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\Program Files\Windows Defender\MsMpEng.exeC:\WINDOWS\System32\svchost.exeC:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exeC:\Program Files\Common Files\Symantec Shared\ccSvcHst.exeC:\Program Files\Common Files\Symantec Shared\AppCore\AppSvc32.exeC:\WINDOWS\system32\spoolsv.exeC:\Program Files\Symantec\LiveUpdate\ALUSchedulerSvc.exeC:\Program Files\Common Files\Symantec Shared\ccSvcHst.exeC:\WINDOWS\system32\CTsvcCDA.exeC:\WINDOWS\system32\nvsvc32.exeC:\Program Files\Common Files\Roxio Shared\9.0\SharedCOM\RoxWatch9.exeC:\WINDOWS\system32\svchost.exeC:\Program Files\Common Files\Roxio Shared\9.0\SharedCOM\RoxMediaDB9.exeC:\Program Files\Common Files\Symantec Shared\CCPD-LC\symlcsvc.exeC:\WINDOWS\Explorer.EXEC:\WINDOWS\system32\rundll32... Read more

A:Text Entered In Fields (login) Automatically Backs Out

I apologize for the very long delay. We have a huge backlog of HijackThis Logs to handle and it has been taking us greater time than normal to get caught up. If you are still having a problem, and want us to analyze your information, please post a brand new hijackthis log. If we do not hear back from you within a couple of days we will need to close your topic.When posting your logs please post them directly into the reply. Do not attach them.Also make sure you have already followed the steps outlined below:Preparation Guide For Use Before Posting A Hijackthis LogThank you for your patience.

Read other 1 answers
RELEVANCY SCORE 56

Hey there folks.. I have what may amount to be a small problem or an easy fix but I can't figure it out for the life of me. I have spent the last week researching this problem, off and on.

What I need help with:

I have a semi-complex database in Access 2007 and I will have several forms. I need the forms to have clear fields when the user opens the form. Is there a way to automatically clear the forms upon opening of the form by the user without the need to click a 'clear' button? If so, how do I go about achieving this end?

Thanks,
Jason
 

A:Solved: Automatically clear form fields when opened

Read other 16 answers
RELEVANCY SCORE 56

Hello.

I am trying to create a contract template for our lawn care business. There are 22 different services that our customers can choose to add, each with a price specific to their own property. At the bottom of the service and pricing list there is a "sub-total" line, with a "5% discount" line underneath, and under that the "total" line.

Like so:

weekly lawn maintenance $35.00 Is there a way to "make" these numbers add up, and
Shrub trimming $150.00 appear in the areas below? So that we don't have to
Fertilization $35.00 manually do all of the calculations, thereby saving
ourselves literally days of work.​Sub-total $220.00
5% discount $11.00
Total $209.00

Also, on the contract we have payment options for our customers. Another big time consumer has been manually calculating these options.

Like so:

$209.00 payable at a flat rate over 9 months (March through November) = $23.22/month
If I can get the "total" number from above to automatically calculate and "jump" to the figures in red above, that would be simply wonderful.

I know that in excel the calculations can be done by creating a spreadsheet (although I do not know how to make a spreadsheet), but I this contract is a legal document and needs to appear so. I'm hoping that Word has a way to do this as well.

FYI, I tried to upload the document but for some reason the only way I can get to the template is if I want to create a docum... Read more

A:Help creating automatically calculating fields in word 2007

Read other 6 answers
RELEVANCY SCORE 56

Hi

I'm working in Access 2000. I created a database in which you select a course number and the course name automatically appears in the "course name" box. I created this database but cannot for the life of me figure out how I did that.

Now I need to do it again...I've looked at the properties of the fields in the form and everything, and cannot find where you point it to fill in one field based on a another.

Can anyone help me with this?

thanks
Bobbi
 

A:Access2000 -Automatically fill in fields based on a selection

Read other 6 answers
RELEVANCY SCORE 55.6

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

A:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

Read other 3 answers
RELEVANCY SCORE 55.6

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

A:Stripping the date portion of date/time in excel

Read other 7 answers
RELEVANCY SCORE 55.6

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

A:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

Read other 2 answers
RELEVANCY SCORE 55.6

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

A:Excel date auto populate date/time

Read other 11 answers
RELEVANCY SCORE 55.6

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

A:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

Read other 3 answers
RELEVANCY SCORE 55.6

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

A:Excel 2007 - Start Date and End date question

Read other 16 answers
RELEVANCY SCORE 55.6

Excel 2013 and Windows 10 Pro

Today is May-14

Date format is set to show: Mar-16
Pressing Ctrl+; shows: 05 14 2016 in the cell
and it converts to: May-16 after I exit that cell.

Any ideas as to how to fix this or why it adds 2 days to the date?

I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

Thank you in advance, Ron
 

A:Excel Date shortcut posts proper date and then changes

Hey Ron,

This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
If you click the format drop down as shown below, and click the last option for more formatting options.

In the box that pops up, navigate to Custom using the left hand panel to navigate.
Here you can make your own (or use a preset if you wish) format to suit your needs.

Here is a quick key to help you get by:
dd = Day in Number format
ddd = Day in Short text
dddd = Day in Long text
mm = Month in Number format
mmm = Month in Short text
mmmm = Month in Long text
yy = year in 2 digits
yyyy = year in 4 digits

You can separate these with pretty much whatever you want.
All of this data is input into the "Type" field as shown in the picture above.

See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

Best of luck,
Let us know how you get on,

Xsage
 

Read other 1 answers
RELEVANCY SCORE 55.6

I created a database and I need to create a form/report which would be a contract for my business. What I want to know is how can i have access automatically fill predefined data such as clients name etc into certain fields automatically for each client record. I basically want to be able to click on the clients record, run a report which would be the contract/agreement and be able to print off contract with the clients name already entered into the applicable fields...

What would the steps be?
 

A:How to create a form/report in Access where some fields are automatically filled

You would not need to fill in any Customer Fields on the form, other than the Key ID Field.
For the report you create a query based on the contract table and the Customer table to get all the fields for the report.
 

Read other 1 answers
RELEVANCY SCORE 54.8

Does anyone know how to convert a date entry from Unix format to Gregorian calendar format?

I have a long table with Unix values for date and want to plot a count of row entries within a certain date range...

Any ideas?
 

A:Excel: Unix date to gregorian date

Also... how do I count the number of occurrences of similar entries in a column... i.e.

1
1
1
2
2
3
3
3
3
4
4

I want to be able to count the number of occurrences of 1, then the number of occurrences of 2 etc etc
 

Read other 2 answers
RELEVANCY SCORE 53.6

My employer just upgraded to Microsoft Office 2007. According to the help files, I should be able to paste Excel charts into Word that update automatically when changes are made to either version.

I am clicking "Link to Excel data" and "Keep source formatting" when using the little popup clipboard to paste a chart into Word. But after closing both files, opening Excel and updating data on the chart, saving and closing Excel and re-opening Word, the chart is not updating with the new information. I can't get it to update by clicking on "refresh data" either.

Does anyone know how this is supposed to work? I was looking forward to being able to update just the Excel file and having it update in all the Word documents where it is pasted.

Our OS is Windows XP Professional, Version 2002, Service Pack 2. My work computer has a Pentium 4, 3 GHz processor and 2 GB of RAM.
 

Read other answers
RELEVANCY SCORE 53.6

Is there a way to set forms up in Excel like Word? When I have the form toolbar open, the Text Form Field icon is grayed out. Thanks for the help!
 

A:Excel Form Fields

There's no Text Form Field icon on Excel's Forms toolbar, it's an EditBox button. It's greyed out because it can't be used on a worksheet, only on a UserForm (custom dialog box).

There are ways you can get Excel to jump to various cells for user input, it depends on exactly what you want to do.

Example:
Click on A3, hold down CTRL, click on A5, A7, A9, A1. Release CTRL. Select Format -- Cells -- Protection, uncheck "Locked", click OK. Protect the worksheet (Tools menu), then you can tab around the sheet in that order (starting with A1).

HTH,
Andy
 

Read other 1 answers
RELEVANCY SCORE 52.8

Hello,

I would like to delete these fields from Excel. Clicking on them I have error. How can I delete them ?

Regards,
 

A:Solved: How to delete these fields in Excel ?

These are not fields, these are either buttons or objects to which a macro is attached.
Normally you should be able to click on this and choose (right mouse) to delete.
Or the sheet is protectd or the item is protected
 

Read other 3 answers
RELEVANCY SCORE 52.8

Comment fields, reference threads and aero peek view appear totally blacked out on secondary screen of a two screen environment. Ipl corrects problem for a while but it comes back in the middle of an active session. Have tried disabling aero peek to no avail. Shuting down excel and restarting sometimes resets the problem but not always.
Env: win 7 office 2010

A:Excel comment fields appear blacked out Win 7

I have experienced a similar issue with a system that has not been restarted for more than 4-5 days. It also affects the file manager dialog windows (ie Save/Save-as) which appear completely blacked out.

A simple restart has always cleared it up for me, until the next multi-day-long session without a full restart.

Read other 4 answers
RELEVANCY SCORE 52.8

Hello, not sure how to explain this but hopefully this will work.

I need to combine the contents of all the cell Bís when cell A has the same contents (in this example 2222 etc.).
........A......B
line 1 2222 object
line 2 2222 box
line 3 2222 something
line 4 2223 circle
line 5 2223 square
line 6 2224 stuff
line 7 2225 glass

When Iím done, my spreadsheet will look like this.
........A......B
line 1 2222 Object, box, Something
line 2 2222
line 3 2222
line 4 2223 Circle, square
line 5 2223
line 6 2224 stuff
line 7 2225 glass

or this. It doesn't matter if the the original contents of the B cells stay as they originally were.
........A......B
line 1 2222 Object, box, Something
line 2 2222 box
line 3 2222 Somthting
line 4 2223 Circle, square
line 5 2223 square
line 6 2224 stuff
line 7 2225 glass

I've been manually cut and pasting but there must be a better way. Microsoft Office Excel 2007

Thanks in advance!
 

A:Solved: Excel help combining fields

Read other 9 answers
RELEVANCY SCORE 52.8

Hi guys,

In a previous thread I have asked how to conditional format fields within a certain time frame and have been given the answer =TODAY()-[No of days].

This works sucessfully, so that if I want to mark every date more than a year old in red the command is =TODAY()-365.

Is there a way that I can then count these fields?

Basically.. after they have been marked red I want to know how many reds i have in each column..

Sorry... im an excel newbie .

Thanks
 

A:Solved: Excel, Counting certain fields

Use the CountIf function.

Select the range of cells that you want to have counted and then enter a condition like >365

That should do what you want to do.
 

Read other 1 answers
RELEVANCY SCORE 52.8

Comment fields, reference threads and aero peek view appear totally blacked out on secondary screen of a two screen environment. Ipl corrects problem for a while but it comes back in the middle of an active session. Have tried disabling aero peek to no avail. Shuting down excel and restarting sometimes resets the problem but not always.
Env: win 7 office 2010

Read other answers
RELEVANCY SCORE 52.8

I am frustrated with the following problem.
I need to convert the date to US formatting.
I receive a file in .csv format and the dates come as text and a normal date format all within the same column.

Example:

12/4/2012 23:16
12/4/2012 23:21
13/04/12 12:04 AM
13/04/12 12:52 AM
13/04/12 3:20 AM

The top 2, Excel reads as date. The bottom 3 excel reads as text...I need the bottom 3 to read as date.

Please HelP!!!
 

A:Excel 2010 UK Date to US Date

Read other 11 answers