is there any way i can keep my format after copying data from a html source.
i need my staff to copy and paste from html and when they paste into a range of cells that i have formatted already, the cell color,borders etc are over ridden.
because it is from html there is no paste values option either. i have also tried conditional formatting but again this is lost once the data is pasted into excel.
is there a macro i can use that will automatically copy the same range format on another sheet and copy the format once they have pasted the html data?
cheers
i need my staff to copy and paste from html and when they paste into a range of cells that i have formatted already, the cell color,borders etc are over ridden.
because it is from html there is no paste values option either. i have also tried conditional formatting but again this is lost once the data is pasted into excel.
is there a macro i can use that will automatically copy the same range format on another sheet and copy the format once they have pasted the html data?
cheers