time specific date input
 

Someone please help. I have been trying for that last two
days to workout a function for a spreadsheet I need for a
big meeting on Monday at work. Please help. Here is my
problem.

I have two sheets in a workbook. Sheet 1 contains month
to date totals. Sheet 2 is a daily account tracking
sheet. I use Sheet 2 daily, and input the tabulated
totals from sheet 2 into sheet 1 manually. However, on
sheet 1 I input the data to its corresponding date. So
everyday I input data into a different row. What I need
is for Sheet 1 to feed off Sheet 2 and to lock in the
data for that specific day. Please look below for a
detailed example.

Sheet1: MTD Totals

Date Total Cured Accounts Follow Up Accts
1/1
1/2 2 1
1/3
1/4
Total


Sheet2: Daily Tracking Sheet

Date: 1/2

Account # Cured Acct (Y/N) Follow Up(Y/N)
8237847 Y N
6943623 N N
9374039 Y Y

Totals 2 1

I need the totals entered from sheet 2 into sheet 1
automatically for the date the sheet is posted. For this
example, it is 1/2 so the data goes into row 1/2 of
Sheet1. It needs to copied as values so that if i delete
sheet2 i dont lose the values on sheet1. I do not want
the data dropping down to the next date when the computer
knows it is the next day. So a function that would allow
the data to hold at 11:30 P.M., then clears Sheet 2 so it
can be used for the next day.


Someone please help, I am at a total loss right now. I
greatly appreaciate it.

time specific date input
 

Hi Ron

If I a example on this page how to copy to
a database sheet
http://www.rondebruin.nl/copy1.htm

Try something and post back with questions


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Ron Albert" wrote in message ...
Someone please help. I have been trying for that last two
days to workout a function for a spreadsheet I need for a
big meeting on Monday at work. Please help. Here is my
problem.

I have two sheets in a workbook. Sheet 1 contains month
to date totals. Sheet 2 is a daily account tracking
sheet. I use Sheet 2 daily, and input the tabulated
totals from sheet 2 into sheet 1 manually. However, on
sheet 1 I input the data to its corresponding date. So
everyday I input data into a different row. What I need
is for Sheet 1 to feed off Sheet 2 and to lock in the
data for that specific day. Please look below for a
detailed example.

Sheet1: MTD Totals

Date Total Cured Accounts Follow Up Accts
1/1
1/2 2 1
1/3
1/4
Total


Sheet2: Daily Tracking Sheet

Date: 1/2

Account # Cured Acct (Y/N) Follow Up(Y/N)
8237847 Y N
6943623 N N
9374039 Y Y

Totals 2 1

I need the totals entered from sheet 2 into sheet 1
automatically for the date the sheet is posted. For this
example, it is 1/2 so the data goes into row 1/2 of
Sheet1. It needs to copied as values so that if i delete
sheet2 i dont lose the values on sheet1. I do not want
the data dropping down to the next date when the computer
knows it is the next day. So a function that would allow
the data to hold at 11:30 P.M., then clears Sheet 2 so it
can be used for the next day.


Someone please help, I am at a total loss right now. I
greatly appreaciate it.