Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Help Reqd urgently

  		Logged in as: Guest
arrSession:exec spGetSession 2,7,41294
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [General Forum] >> Other Programming/Scripting Languages >> Help Reqd urgently
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Help Reqd urgently - 12/20/2006 11:39:49 PM   
  beckham_madrid0

 

Posts: 0
Score: 0
Joined: 12/20/2006
Status: offline 		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
 
 
Post #: 1
 
RE: Help Reqd urgently - 12/21/2006 1:59:21 AM   
  ebgreen


Posts: 4595
Score: 29
Joined: 7/12/2005
Status: offline 		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

(in reply to beckham_madrid0)
 
 
Post #: 2
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [General Forum] >> Other Programming/Scripting Languages >> Help Reqd urgently Page: [1]
Jump to:





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
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI