Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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 

excel
MS Office Version: 2010
posted by: siddeek on Mon Jul 30, 2018 at 6:16 am
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: 1989) 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: 1989) 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