I have a spreadsheet A_(sheet with mixed coloumns of currency cells(DKK) and others (kg). ,
I want to copy to another sheet B_sheet where all currency cells(DKK) are converted to another currency(EUR) but all other cells(kg) remain the same.
Can I do that in an easy way?
My solusion would be to change one cell and copy paste, but I have many coloumns.