hi, i tried to transfer data from many sheet to one sheet in one workbook i found somthing different. the destination sheet was created by the insert table option but the data is pasting fe lines below then delete and tried again pasting more lines below.
then delete the table and paste it was pasted peffectly.so why didnot paste for the table option
data has to appear destination sheet while typing another sheet