Apologies for the bad ettiquete, I was posting on my phone due to not being able to do it on the work computer.
I am trying to upload the file i have the code in.
What I am trying to do is in the end have a small table in the tab called visits (the headers are already there) which lists all the instances in which the letter is found on the workbook on the tab called Main.
The table should have the name of the course (of that row) and the date of where the letter is found (would be the same column the letter is but at the top of the table with all the dates.
I would have deleted the extra columns but didn't since they matter for my numbering purposes.
The Command Button 9 in the macros is the one that I'm trying to make work. It is the large square button at the bottom. I have done (attempted) to have the code go through the first row of the calendar only and I have not done any steps to attempt the code go over the whole range of the "calendar"
I hope this makes my end state more clear.
Thank you again
Reply With Quote