+ Reply to Thread
Results 1 to 3 of 3

Copy rows based on criteria to new sheet, controll the destination range.

  1. 11-04-2014, 02:11 PM #1
    Petter120
    Petter120 is offline
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Copy rows based on criteria to new sheet, controll the destination range.

    Hi

    I have this code to copy rows from sheet "data" to sheet "översikt". 


    Please Login or Register  to view this content.
    Everything works fine exept i cant figure how to controll wich line it starts to paste from.

    Right now i have a header on Row1 and it starts to paste in row 2.
    I want to be able to choose with row it should start from like row 4 or 5, wich section of the code controlls that ?

    Petter
    Reply With QuoteRegister To Reply
  2. 11-04-2014, 02:49 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy rows based on criteria to new sheet, controll the destination range. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-04-2014, 02:50 PM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy rows based on criteria to new sheet, controll the destination range. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  2. Copy rows to a given sheet based on several criteria
    By bfora in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-02-2013, 11:12 AM
  3. Copy data based on multi criteria to another sheet and hide rows using range on sep sheet
    By suzig in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  4. Copy Rows from Sheet 1 based on Criteria
    By ppeter01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2008, 05:18 PM
  5. Copy Rows In New Sheet Based On Date Range Criteria
    By ahmedwaseem2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2006, 05:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1