My reply seems to have disappeared.. weird.

Thank you for your help. I think this will work, with a few
adjustments. How can I combine this macro with the one I mentioned
earlier? Also, how can I designate the sequence of cells to edit start
with D4?


Thanks!

-Alden


On Jun 17, 6:57 am, Gary''s Student
wrote:
I am not certain that I understand you exact needs. Lets say I have just
created a set of sheets within a workbook and I want to make column headers
in a sheet called "summary".

I want to get the headers from the sheet names (person names), skipping some
columns in the process

Sub jason()
Sheets("summary").Activate
k = 1
For Each w In Sheets
nm = w.Name
If nm < "summary" Then
Cells(1, k).Value = nm
k = k + 4
End If
Next
End Sub

Try this out on a scrap workbook first.
--
Gary''s Student - gsnu200730