Can get it name the sheet if cell referencing is text. However, the cel
contains date imported from csv file in format of 5/3/2004
the one summary being copied has all the formulas to build a dail
summary based on input from cms.
Am thinking that maybe the actual date will need to be reassemble
somehow?
Can select cell and copy, then manually rename the sheet with pastin
it in. Would be nice if it can be done via VBA during the sheet cop
process.
Hope this clarifies, thank you for responding earlier

--
Message posted from http://www.ExcelForum.com