Hello all,
I need to identify an amount entered by a specific date in the "daily" sheet to its location in the "monthly" sheet..
How could i do this?
Hello all,
I need to identify an amount entered by a specific date in the "daily" sheet to its location in the "monthly" sheet..
How could i do this?
Hi, welcome to the forum
care to explain, in more detail, what you are doing and what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I need to enter a transaction in the general ledger that it classified directly by month and date in the calendar
is this what you mean? In monthly C3, copied down and then into the other boxes.
=SUMIF(Daily!$C:$C,Monthly!B3,Daily!$B:$B)
or if you don't want to see all those zeros...
=iferror(1/(1/SUMIF(Daily!$C:$C,Monthly!B3,Daily!$B:$B)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks