Dear all

Sheet1 full of data. Sheet2 has select info linked to some cells from sheet1.

This is sheet2 when exported gives undesired results.

Is it the only way to write in VB to copy and paste only the values??

Pls suggest how to copy say the linked sheet2 to be pasted in new workbook
with formats, like same width of coulmns and rows, coloring and most of all
only the values. Or in VB do I have to copy and paste in new workbook as
values and then as Mr. Mark suggested to create a macro to format the first
row of column and paste the format to the remaining rows.

Would like to know best way to do it, though I have been doing with
activesheet.paste and then format the cells or sheep copy to new work book..

Pls hlep

brgds/captgnvr