More macro

Es · Apr 22, 2004

I need to copy a whole spreadsheet and paste as value.
, and then in column A replace all the values that is
not "Header" with "Detail"
Thanks

Don Guillett · Apr 22, 2004

Have you tried recording the macro while you actually do this?

Frank abel · Apr 22, 2004

Hi
one way to get started: Record a macro while doing this
manually. After this check the code but this should be
quite straight-forward