R
Ron Albert
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.
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.