G
Guest
I have a database of information in excel and need a formula for compiling
totals and transferring it to the main worksheet page. Basically it is a
payment tracker - I put in todays date, account number, payment amount, etc
and hit submit - it then sends this info onto the next worksheet page (the
database). On the main page I have weekly, and monthly totals. I need it to
update the weekly monthly totals based on the actual week and month - not
last 7 days or last 30 days. How can i do this? Ultimately what it needs to
do is go to the second page and grab all the info for the current week
starting Monday and total up the payments and then bring it back to the main
page, and the same for the current month.
Thank you in advance!
totals and transferring it to the main worksheet page. Basically it is a
payment tracker - I put in todays date, account number, payment amount, etc
and hit submit - it then sends this info onto the next worksheet page (the
database). On the main page I have weekly, and monthly totals. I need it to
update the weekly monthly totals based on the actual week and month - not
last 7 days or last 30 days. How can i do this? Ultimately what it needs to
do is go to the second page and grab all the info for the current week
starting Monday and total up the payments and then bring it back to the main
page, and the same for the current month.
Thank you in advance!