+ Reply to Thread
Results 1 to 2 of 2

copy data to different start row

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    copy data to different start row

    Hi guys am using the below code to transfer Columns of data from sheet "EmployeeData" to Sheet "TrainingData", this all works fine but i would like when the data is transfered for the data to start on Row 3, i need to do it as columns as the data constantly changes, any help appreciated

    scouse13

    Please Login or Register  to view this content.
    Last edited by davesexcel; 08-13-2020 at 08:04 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: copy data to different start row

    You can find the last row, then set the ranges to equal each other

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy data using start and end date to another sheet
    By Zahid0111 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-14-2020, 12:59 PM
  2. [SOLVED] How can I do copy data from another tab that does not start from row 1 and keep the order?
    By alexgon212 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2018, 10:10 AM
  3. Replies: 3
    Last Post: 09-03-2014, 09:59 AM
  4. VBA: To have maco start at cell b26 and copy table until there is no data?
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 08:13 AM
  5. [SOLVED] Copy variable amount of rows between Start and End to Start
    By EDo1981 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 07:37 AM
  6. copy data from start to end range
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2009, 01:24 AM
  7. [SOLVED] start a copy of data at a line depending on date
    By news in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2006, 06:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1