Hi, I'm trying to build/refresh a summary sheet using a macro that pull
key data from other sheets.
I have started with listing the names of the other sheets with the d
loop below and this works ok. The command lines commented out is wher
I am having trouble. I would like to populate rows in the summary shee
with some data from the other sheets. I tried to use 'evaluate' , bu
not sure how to call the sheet using sheet numbers, I also tried a tem
variable for the sheet name, but could not get that to work either. Ca
anyone help with the correct way to do this?

For i = 1 To Sheets.Count - 1
Cells(1 + i, 2).Value = Sheets(i + 1).Name
' Cells(1 + i, 8).Value = Evaluate(Sheets(i + 1).Name!h6)
' tempb = Sheets(i + 1).Name
' Cells(1 + i, 8).Value = Evaluate(tempb!h6)
Next i


Thanks
Nei

--
neilgran
Posted from - http://www.officehelp.i