Excel VBA

0

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 

Answer
Discuss

Discussion

If you edit your question, add a more detailed explanation of the issue, and upload a sample file that illustrates the issue, we could provide a helpful answer.
don (rep: 1745) Jul 30, '18 at 10:56 am
simply,apply a table from insert tool bar then make it this destinatin sheet. creat a macro send the destination sheet i am sure it will not paste propely try it and answer me  i hope you could understand thanks further send personally mail
siddeek Jul 31, '18 at 2:49 am
The issue is that the macro that you use could contain so many different things in it so I can't test the issue without seeing the code that you use.
don (rep: 1745) Aug 1, '18 at 2:00 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login