More macro

[Es]

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]

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

 

[Frank abel]

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