+ Reply to Thread
Results 1 to 2 of 2

VBA to copy non empty cells then paste to next available cell in another worksheet

  1. 08-15-2014, 07:10 AM #1
    Chrisbrough88
    Chrisbrough88 is offline
    Registered User
    Join Date
    08-12-2014
    Location
    Merseyside
    MS-Off Ver
    Office 2010
    Posts
    38

    VBA to copy non empty cells then paste to next available cell in another worksheet

    I want a macro which will copy all the data from sheet 1 in columns A:C ignoring any blanks

    then paste it into the first free cell in column B of sheet 2

    Thanks
    Reply With QuoteRegister To Reply
  2. 08-15-2014, 08:07 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA to copy non empty cells then paste to next available cell in another worksheet

    .
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    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. [SOLVED] Copy/paste range of cells to first empty row of active list in another worksheet
    By wildecat666 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-06-2013, 03:45 PM
  2. how to copy a range of cells, paste them and then find next empty cell
    By comp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 03:34 PM
  3. [SOLVED] Copy and Paste Cells to Next empty cell in range
    By oddinho2 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-20-2013, 12:51 PM
  4. VBA to copy selected cells down to empty cell and paste
    By rioutousgnome in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2013, 01:55 PM
  5. Copy Range from Worksheet 2, Paste to Next Empty Row Worksheet 1
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2010, 04:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1