Posted: Fri Oct 31, 2008 11:12 am Post subject: copying info from different sheets into a new sheet
Hi,
I'm new at VBA coding and I really need help with this. I'm trying to write a code that can copy info from different worksheets in the same workbook and put them in a new named sheet.
Try doing the work you want the code to perform while recording the VBA code.
Looking at the VBA code (Alt + F11) you should have some idea to customize the code.
Some of the code snippets that you may need may be...
Workbooks.add (to create a new workbook)
Activesheet.Paste (To paste a range already copied)
selection.copy
or Range("a1:b5").copy (To Copy from A1 to B5)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum