software

Hi -

Please forgive my ignorance but I just don't know anything about Excel. I
have an expense report that I have to file monthly that has to show daily
mileage for both company and personal mileage. I want to automate the
functions as much as I can as an aid to ensuring accuracy. Each day has its
own line and data with totals for the data at the bottom. Here are my
questions:

1) How do I get the current date to automatically load into the appropriate
cell? In other words, when I open this file daily how do I get the current
date to appear in the cell but still retain the option of changing it in case
I forget to update daily.

2) The report asks for beginning and ending odometer readings. I'd like to
be able to just input that data and have the 'daily mileage' show up
automatically. One caveat is that if I have any personal miles for that
particular day, the business mileage should be decreased by that amount. I'd
like to have this in the computation also.

3) In accordance with all of this, the monthly total (on a daily basis)
should be incremented by the daily figures.

Thank you in advance for your assistance. It's greatly appreciated.

Farquhardt=TODAY() will give you the current computer date but you can't change it to
a fixed date and later expecting it to be the current date again unless you
use a macro that will change to current date everytime you open the
workbook, I'd suggest using 2 cells, one with the current date and one where
you can put any date you want.

If not you can right click the excel icon left of the file menu and select
view code and paste in this

Private Sub Workbook_Open()
Range(quot;A1quot;).Value = Format(Date, quot;mm/dd/yyquot;)
End Sub

which will do what TODAY() does but you can overwrite it and next time it
is opened it will insert the current date

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Farquhardtquot; gt; wrote in message
...
gt; Hi -
gt;
gt; Please forgive my ignorance but I just don't know anything about Excel. I
gt; have an expense report that I have to file monthly that has to show daily
gt; mileage for both company and personal mileage. I want to automate the
gt; functions as much as I can as an aid to ensuring accuracy. Each day has
gt; its
gt; own line and data with totals for the data at the bottom. Here are my
gt; questions:
gt;
gt; 1) How do I get the current date to automatically load into the
gt; appropriate
gt; cell? In other words, when I open this file daily how do I get the current
gt; date to appear in the cell but still retain the option of changing it in
gt; case
gt; I forget to update daily.
gt;
gt; 2) The report asks for beginning and ending odometer readings. I'd like to
gt; be able to just input that data and have the 'daily mileage' show up
gt; automatically. One caveat is that if I have any personal miles for that
gt; particular day, the business mileage should be decreased by that amount.
gt; I'd
gt; like to have this in the computation also.
gt;
gt; 3) In accordance with all of this, the monthly total (on a daily basis)
gt; should be incremented by the daily figures.
gt;
gt; Thank you in advance for your assistance. It's greatly appreciated.
gt;
gt; Farquhardt
gt;Hi Peo

gt; If not you can right click the excel icon left of the file menu
Thanks Peo, I had never realised that this would take you straight to
the ThisWorkbook code module.

--
Regards

Roger Govierquot;Peo Sjoblomquot; gt; wrote in message
...
gt; =TODAY() will give you the current computer date but you can't change
gt; it to a fixed date and later expecting it to be the current date again
gt; unless you use a macro that will change to current date everytime you
gt; open the workbook, I'd suggest using 2 cells, one with the current
gt; date and one where you can put any date you want.
gt;
gt; If not you can right click the excel icon left of the file menu and
gt; select view code and paste in this
gt;
gt; Private Sub Workbook_Open()
gt; Range(quot;A1quot;).Value = Format(Date, quot;mm/dd/yyquot;)
gt; End Sub
gt;
gt; which will do what TODAY() does but you can overwrite it and next
gt; time it is opened it will insert the current date
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Farquhardtquot; gt; wrote in message
gt; ...
gt;gt; Hi -
gt;gt;
gt;gt; Please forgive my ignorance but I just don't know anything about
gt;gt; Excel. I
gt;gt; have an expense report that I have to file monthly that has to show
gt;gt; daily
gt;gt; mileage for both company and personal mileage. I want to automate the
gt;gt; functions as much as I can as an aid to ensuring accuracy. Each day
gt;gt; has its
gt;gt; own line and data with totals for the data at the bottom. Here are my
gt;gt; questions:
gt;gt;
gt;gt; 1) How do I get the current date to automatically load into the
gt;gt; appropriate
gt;gt; cell? In other words, when I open this file daily how do I get the
gt;gt; current
gt;gt; date to appear in the cell but still retain the option of changing it
gt;gt; in case
gt;gt; I forget to update daily.
gt;gt;
gt;gt; 2) The report asks for beginning and ending odometer readings. I'd
gt;gt; like to
gt;gt; be able to just input that data and have the 'daily mileage' show up
gt;gt; automatically. One caveat is that if I have any personal miles for
gt;gt; that
gt;gt; particular day, the business mileage should be decreased by that
gt;gt; amount. I'd
gt;gt; like to have this in the computation also.
gt;gt;
gt;gt; 3) In accordance with all of this, the monthly total (on a daily
gt;gt; basis)
gt;gt; should be incremented by the daily figures.
gt;gt;
gt;gt; Thank you in advance for your assistance. It's greatly appreciated.
gt;gt;
gt;gt; Farquhardt
gt;gt;
gt;
if you type hold down ctrl and then press ; you will get the current date
which will remain fixed.....you can of course overwrite it at any time
--
paul
remove nospam for email addy!
quot;Roger Govierquot; wrote:

gt; Hi Peo
gt;
gt; gt; If not you can right click the excel icon left of the file menu
gt; Thanks Peo, I had never realised that this would take you straight to
gt; the ThisWorkbook code module.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt; gt; =TODAY() will give you the current computer date but you can't change
gt; gt; it to a fixed date and later expecting it to be the current date again
gt; gt; unless you use a macro that will change to current date everytime you
gt; gt; open the workbook, I'd suggest using 2 cells, one with the current
gt; gt; date and one where you can put any date you want.
gt; gt;
gt; gt; If not you can right click the excel icon left of the file menu and
gt; gt; select view code and paste in this
gt; gt;
gt; gt; Private Sub Workbook_Open()
gt; gt; Range(quot;A1quot;).Value = Format(Date, quot;mm/dd/yyquot;)
gt; gt; End Sub
gt; gt;
gt; gt; which will do what TODAY() does but you can overwrite it and next
gt; gt; time it is opened it will insert the current date
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Northwest Excel Solutions
gt; gt;
gt; gt; www.nwexcelsolutions.com
gt; gt;
gt; gt; (remove ^^ from email address)
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Farquhardtquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hi -
gt; gt;gt;
gt; gt;gt; Please forgive my ignorance but I just don't know anything about
gt; gt;gt; Excel. I
gt; gt;gt; have an expense report that I have to file monthly that has to show
gt; gt;gt; daily
gt; gt;gt; mileage for both company and personal mileage. I want to automate the
gt; gt;gt; functions as much as I can as an aid to ensuring accuracy. Each day
gt; gt;gt; has its
gt; gt;gt; own line and data with totals for the data at the bottom. Here are my
gt; gt;gt; questions:
gt; gt;gt;
gt; gt;gt; 1) How do I get the current date to automatically load into the
gt; gt;gt; appropriate
gt; gt;gt; cell? In other words, when I open this file daily how do I get the
gt; gt;gt; current
gt; gt;gt; date to appear in the cell but still retain the option of changing it
gt; gt;gt; in case
gt; gt;gt; I forget to update daily.
gt; gt;gt;
gt; gt;gt; 2) The report asks for beginning and ending odometer readings. I'd
gt; gt;gt; like to
gt; gt;gt; be able to just input that data and have the 'daily mileage' show up
gt; gt;gt; automatically. One caveat is that if I have any personal miles for
gt; gt;gt; that
gt; gt;gt; particular day, the business mileage should be decreased by that
gt; gt;gt; amount. I'd
gt; gt;gt; like to have this in the computation also.
gt; gt;gt;
gt; gt;gt; 3) In accordance with all of this, the monthly total (on a daily
gt; gt;gt; basis)
gt; gt;gt; should be incremented by the daily figures.
gt; gt;gt;
gt; gt;gt; Thank you in advance for your assistance. It's greatly appreciated.
gt; gt;gt;
gt; gt;gt; Farquhardt
gt; gt;gt;
gt; gt;
gt;
gt;
gt;