macro to copy and paste data from multiple sheets

  • Thread starter Thread starter paritoshmehta
  • Start date Start date
P

paritoshmehta

Hi,

I have this file over here where I have to copy the 50th row fro
different sheets and paste all of them one by one into one main shee
within that excel file only....

Also, all the worksheet name needs to be pasted in the first cell o
the row

eg : for sheet 2, the row (50:50) is selected and pasted in first ro
of the Main sheet and A1 would show the name of the sheet (sheet2)

If someone could help us create a macro for this.....

Thanks for any help possible!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
copy and paste data from different sheets 1
Search , then copy and paste from multiple worksheets. VBA help 1
Create if partial match then copy and paste data from one cell to another 1
Run two macros for two different sheets 11
copy and paste data only to a new file 1

Back
Top