abraham30
11-29-2013, 05:23 AM
Hi,
I want to copy the data from selected row (suppose R1 to R10) from sheet "Data1" and then paste into another sheet "Data2", the headers are not being populated properly.
As the fonts in the header are in some other language, the original requester want the header to be exactly same (without any space) to the copied one which I am not able to do.
e.g. I copied the data from R1-R10 and paste in other sheet "Data2". -->i) Header in column c are not populated exactly .
ii) Header in column I of sheet Data1 is more widened compared to col I of data2.
Is it possible to develop macro which will keep the exact copy to copied sheet. (See attached sheet)
Advance thanks
I want to copy the data from selected row (suppose R1 to R10) from sheet "Data1" and then paste into another sheet "Data2", the headers are not being populated properly.
As the fonts in the header are in some other language, the original requester want the header to be exactly same (without any space) to the copied one which I am not able to do.
e.g. I copied the data from R1-R10 and paste in other sheet "Data2". -->i) Header in column c are not populated exactly .
ii) Header in column I of sheet Data1 is more widened compared to col I of data2.
Is it possible to develop macro which will keep the exact copy to copied sheet. (See attached sheet)
Advance thanks