Copy a cell with the format

[mgw1138]

I need to move a series of cells from various sheets to a new "master" sheet. Some are text, some are numbers, some are percents and two are dates. Is there a method or cell attribute assignment that will do this for me? Thanks

 

[My Aswer Is This]

Sure this can be done using Vba.

Provide specific details and we can provide code.

 

[mgw1138]

I have data in 85 different sheets. In VBA I am scanning through the sheets and moving needed row to the "new master" tab. That is working correctly. However on some tabs Range("a1") is numeric and on others it is date. I need to some the value from each of these sheets to the "new master" along with the format from the "target" tab cell. These can be numeric, date, percent or text.

Thanks in advance