VBA code to copy data from one sheet to other

Posted on 2012-09-10
Last Modified: 2012-09-19
I have two excel sheets with variable length.
Want to copy from one sheet to other, I know if I loop raw and column it can be done.
if there any way to copy entire raw at a time ...more faster way.

Question by:alam747
    LVL 24

    Accepted Solution

    to copy an entire row (example will copy row1 sheet1 to row1 sheet2)...

    dim wsF as worksheet: set wsF = thisworkbook.sheets("Sheet1")
    dim wsT as worksheet: set wsT = thisworkbook.sheets("Sheet2")
    wsF.rows(1).copy wsT.rows(1)

    Open in new window


    Author Closing Comment


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now