B
bethdo97
I have created a simple income daysheet for my medical practice. The idea is
for all money collected and received in a day to be inputted in that day's
day sheet along with the source of the money, why it was received and if
there is a check or statement number associated with the payemnt for it to be
recorded.
My questions are:
1. Column A is for date - I want to automatically enter the current date in
each cell in column A. So when a new payment is being entered the current
date is automatically entered for the payment clerk. I can get the date in 1
cell using the date function but usn't there a way to get it to apply to a
whole colun?
2. When the daysheet worksheet is opened each day I want a new worksheet
started for that day's business. At the end of the month I should have a
workbook with 28, 30, or 31 days depending on how many days are in the month
and how many days we are open. Should I do this with a sort function and
sort the data to a new worksheet?
3. Finally, I have 2 columns one for deposit posted to patient account and
one for deposit added to checkbook deposit. I would like these to be check
marks so that when the cell in that row is marked a check mark will appear to
indicate that the job has been done. I don't want the check mark to
automatically appear. I have another worksheet that does this but I can't
figure out how the author formatted the columns to do this.
I can send a copy of the worksheet I have come up with to you if it would be
easier to see what I am talking about. My knowledge of excel islimited to
what I learned by teaching myself from a book I purchasedon learning excel.
Thanks in advance for any help you can give me.
Beth Sullivan
for all money collected and received in a day to be inputted in that day's
day sheet along with the source of the money, why it was received and if
there is a check or statement number associated with the payemnt for it to be
recorded.
My questions are:
1. Column A is for date - I want to automatically enter the current date in
each cell in column A. So when a new payment is being entered the current
date is automatically entered for the payment clerk. I can get the date in 1
cell using the date function but usn't there a way to get it to apply to a
whole colun?
2. When the daysheet worksheet is opened each day I want a new worksheet
started for that day's business. At the end of the month I should have a
workbook with 28, 30, or 31 days depending on how many days are in the month
and how many days we are open. Should I do this with a sort function and
sort the data to a new worksheet?
3. Finally, I have 2 columns one for deposit posted to patient account and
one for deposit added to checkbook deposit. I would like these to be check
marks so that when the cell in that row is marked a check mark will appear to
indicate that the job has been done. I don't want the check mark to
automatically appear. I have another worksheet that does this but I can't
figure out how the author formatted the columns to do this.
I can send a copy of the worksheet I have come up with to you if it would be
easier to see what I am talking about. My knowledge of excel islimited to
what I learned by teaching myself from a book I purchasedon learning excel.
Thanks in advance for any help you can give me.
Beth Sullivan