Help Reqd urgently

Author Message
beckham_madrid0

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 12/21/2006
  • Status: offline
Help Reqd urgently Thursday, December 21, 2006 12:39 AM (permalink)
0
Original message moved by mbouchard
Reason : Moving to correct Forum
Hi ,
 
I have got an excel file it has 5 tabs with data in it.
i want to copy paste all the data from those 5 tabs into a new tab in the same excel file.
 
Thnks in advance,
Mayur
 
#1
    ebgreen

    • Total Posts : 8227
    • Scores: 98
    • Reward points : 0
    • Joined: 7/12/2005
    • Status: offline
    RE: Help Reqd urgently Thursday, December 21, 2006 2:59 AM (permalink)
    0
    start the macro recorder, then do whatever it is that you need to do. Then open the macro in the Visual Basic editor. There is the code to do whatyou want.
    "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
    Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
    http://www.visualbasicscript.com/m_47117/tm.htm
     
    #2

      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2012 ASPPlayground.NET Forum Version 3.9