Dim shts As Worksheet
Dim Ws As Worksheet
Set Ws = Worksheets("Master Data")
For Each shts In Sheets
If shts.Name <> Ws.Name Then
.Cells(Rows.Count, "A").End(xlUp).EntireRow.Copy _
Ws.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
|Comment||Very quick answer.|
Answers by Expert:
I can answer most excel questions My Website is davesexcel.com
I have been working with spreadsheets since 1991.
I am a self-trained excel developer since 2005.
My website davesexcel.com
Business admin. U of R.
Awards and Honors
Microsoft Excel MVP 2011-2012