Tom Ogilvy wrote

You leave out many important details such as where to place the second
set of data, what the sheet names are and so forth.

Final list to be a combined/merged list as opposed to continuous.

Column A contains names of people who attend program and may eat breakfast
and/or lunch or may not eat at all. Those who ate breafast have a checkmark
entered in a column under the current date to the right of their name.
Ditto for lunch. I want all who ate either meal to have their checkmarks
copied for the current date to the current date cells opposite their name
on the Attendance sheet. This is so after lunch the user will only have to
add checkmarks to the Attendance sheet for those that have not already been
accounted for when they ate.

We are a Title XX Food Program and totals for meals served and who ate them
are required to be reported monthly.

This was not a problem and my supplied code handled it nicely when we only
served lunch. Now we serve breakfast, too.

"Attendance" named-range common for all sheets to identify length of
row/col cell data to copy and also used to clear checkmarks in a routine
that empties range on each sheet and sets dates for the next month.

Sheets named as follows

Breakfast(1) Lunch(1) Attendance - checkmarks = X in this example
Name1 X X X
Name2 X X
Name3 X X
Name4 X 'added by user after lunch

--
David