I am having trouble to get the 3rd FindNext to work in my document.
I am trying to find the expense amount for 1 job but 3 entries for that 1 "Job Name" in the data sheet and pasting it into a separate report.
It works fine if it only needs to find 2 entries for the "Job Name"but when it goes to find the 3rd "Job Name" it finds the 2nd one again and repeats the data for the 2nd "Job Name" rather than the 3rd "Job Name".
Please if anyone can give me any help as I would like to allow for 4 entries per "Job Name" as that would be the most entries per "Job Name"per month.
A dummy of the 2 spreadsheets that I am using are attached.
I have assigned crtl+shift+P for the code to run from "Pay & Reserves report-Marrero2" spreadsheet.
Thanks
Bookmarks