Forum Discussion

Tim_Lumpkins's avatar
Tim_Lumpkins
Copper Contributor
Jun 21, 2023

I am new to formulas and functions in Excel. anyone's help would be greatly appreciated.

I have a Excel file with 5 sheets.  The first sheet is filled out on a daily basis on children that pay their monthly Tuition.  The next 3 sheets tract that information by class.  The 5th sheet is where i am needing help.  it takes the data in Tuition and makes a receipt that will be printed for the parent.  

The Index and Match works great in sheets 2-4 but I need sheet 5 to know when it has completed one student receipt and move to the next in matching Month and Date from the first sheet.  

i hope i explained this but if you should have any questions about my problem, please let me know.  

Resources