How can I copy Data from one sheet to another Sheet in Excel 07 Through Macro

Posted by Mwaseem Alvi on Stack Overflow See other posts from Stack Overflow or by Mwaseem Alvi
Published on 2010-03-16T12:04:32Z Indexed on 2010/03/16 12:06 UTC
Read the original article Hit count: 379

Filed under:

ms

|

Office

|

excel

|

macro

|

issue

Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail.

Sheet one: Copy the data from column B and Row 3

Sheet Two: Paste the Copied Data in Column B and Row 3

Sheet One: Copy the whole data from Column B to Column G and Row 5 to onward

Sheet Two: Paste whole copied data in sheet two from last filled row to onward

Data dont overwrite on any row or column. Every data will be add in sheet two from sheet one when macro will be run.

Thanks

© Stack Overflow or respective owner

Related posts about ms

Why does traceroute take much longer than ping?

as seen on Server Fault - Search for 'Server Fault'
How to explain this? C:\Documents and Settings\Administrator>tracert google.com Tracing route to google.com [64.233.189.104] over a maximum of 30 hops: 1 <1 ms <1 ms <1 ms 192.168.0.1 2 7 ms <1 ms <1 ms reserve.cableplus.com.cn [218.242.223.209] 3 … >>> More
Help analyzing traceroute

as seen on Server Fault - Search for 'Server Fault'
Hello, my name is Abdulla and I'm from Kuwait. Sorry for my question as I know its not technically challenging. I'm facing some problems with my internet connection. My company has a DSL 2mb connection. My main problem is latency, in the morning its good but after that its gets really bad. My Internet… >>> More
Please bear with me, can someone analyze this trace route please

as seen on Server Fault - Search for 'Server Fault'
Hello, my name is Abdulla and I'm from Kuwait. Sorry for my question as I know its not technically challenging. I'm facing some problems with my internet connection while gaming, I have DSL 2mb connection. My main problem is latency, in the morning its good but after that its gets really bad. My… >>> More
SharePoint 2010 Center and Fixed Width of all content on page including the ribbon

as seen on Stack Overflow - Search for 'Stack Overflow'
All, I am trying to make the width of the sharepoint 2010 web site to be within a fixed width and centered across the screen. I would like for it to be 800px and centered. When i do this, it seems like it starts to work until the ribbion bar renters. Here is my attempt so far: body.v4/* _lcid="1033"… >>> More
Optimizing transition/movement smoothness for a 2D flash game.

as seen on Stack Overflow - Search for 'Stack Overflow'
Update 6: Fenomenas suggested me to re-create everything as simple as possible. I had my doubts that this would make any difference as the algorithm remains the same, and performance did not seem to be the issue. Anyway, it was the only suggestion I got so here it is: 30 FPS: http://www.feedpostal… >>> More

Related posts about Office

How To Activate Your Free Office 2007 to 2010 Tech Guarantee Upgrade

as seen on How to geek - Search for 'How to geek'
Have you purchased Office 2007 since March 5th, 2010? If so, here’s how you can activate and download your free upgrade to Office 2010! Microsoft Office 2010 has just been released, and today you can purchase upgrades from most retail stores or directly from Microsoft via download. But… >>> More
"Error in the Site Data Web Service." when performing crawl

as seen on Server Fault - Search for 'Server Fault'
Installed SharePoint Services v3 (SP2, october 2009 cumulative updates, Language Pack), attached to a content database I had previously (all works). Installed Search server 2008 Express (with language pack) on top of WSS and crawl does not work. However it works for newly created web application +… >>> More
OCR anything with OneNote 2007 and 2010

as seen on How to geek - Search for 'How to geek'
Quality OCR software can often be very expensive, but you may have one already installed on your computer that you didn’t know about. Here’s how you can use OneNote to OCR anything on your computer. OneNote is one of the overlooked gems in recent versions of Microsoft Office. OneNote… >>> More
How To Switch Back to Outlook 2007 After the 2010 Beta Ends

as seen on How to geek - Search for 'How to geek'
Are you switching back to Outlook 2007 after trying out Office 2010 beta? Here’s how you can restore your Outlook data and keep everything working fine after the switch. Whenever you install a newer version of Outlook, it will convert your profile and data files to the latest format. … >>> More
Add Your Gmail Account to Outlook 2010 Using IMAP

as seen on How to geek - Search for 'How to geek'
If you’re upgrading from Outlook 2003 to 2010, you might want to use IMAP with your Gmail account to synchronize mail across multiple machines. Using our guide, you will be able to start using it in no time. Enable IMAP in Gmail First log into your Gmail account and open the Settings panel… >>> More