+ Reply to Thread
Results 1 to 3 of 3

copy data from one column to column on another sheet starting with first open cell

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    belleville il
    MS-Off Ver
    Office 365/Excel 2013
    Posts
    18

    copy data from one column to column on another sheet starting with first open cell

    okay so google is being maddeningly unhelpful here......

    so im trying to write a macro that takes the data from a column in one sheet and copies it to the B column in a master sheet starting at the first available cell in column B.
    im setting the macro at present to just run on the active sheet so i can just go through the sheets manually as i fill them out.
    this is what i have at this point.

    Sub PopulatePlayers()
    ActiveSheet.Range("b2:b65536").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("Overall Leaderboard").Range("B2").End(xlDown).Offset(1, 0), Unique:=True
    End Sub

    any suggestions? please and thank you.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: copy data from one column to column on another sheet starting with first open cell

    This will loop through all the worksheets if that's what you want.

    AdvancedFilter assumes the top cell (B1 in the case) in the filter range to be a header.

    Please Login or Register  to view this content.
    This copies from just the activehseet.

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 08-26-2013 at 01:47 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-18-2013
    Location
    belleville il
    MS-Off Ver
    Office 365/Excel 2013
    Posts
    18

    Re: copy data from one column to column on another sheet starting with first open cell

    this works 99% of the way i need it to thank you. the one part i need it to do is actually read the first row as well as it is relevant data not a header. whats the adjustment needed?

+ 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. Macro to search for text then copy data from that row starting in different column
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2013, 10:43 AM
  2. Copy column data on one sheet to row or column date on another sheet based on user in
    By soready42012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2012, 12:03 AM
  3. create multiple column rows starting from data in one column
    By thotosch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2012, 01:20 AM
  4. Replies: 0
    Last Post: 05-24-2010, 05:17 PM
  5. Copy Data from Column and Paste to Next Blank Column on 2nd Sheet
    By adammark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2010, 11:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1