Closed Thread
Results 1 to 3 of 3

VBA code for Copy paste multiple tables skipping blank in to another worksheet

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Post VBA code for Copy paste multiple tables skipping blank in to another worksheet

    Hi I have one excel worksheet which contains 25 tables for 25 different clients. One table contains day wise data for transactions over period of 3-4 years for one client. For e.g. Table 1 is From Column A to Column N for Client no.1 & rows contain day wise transactions for 3-4 years, Table 2 from column P to Column AC is for Client no. 2 so on and so forth. Each table has 14 Columns and I want to copy Three important column from each table into another worksheet and while copying I don’t want few cells which are blank (These cells are no transactions days for a client. Each client’s no transaction day may be different).

    In nutshell I want to copy client wise three columns from one worksheet in to separate sheet with ignoring blank cells. I have gone through Macro & array formulae & filter which will copy non blank cell data into another worksheet. Array formulae is making file very slow. Can any one help me with macro in relation to this which can be used for all 25 tables together ?

    Regards

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: VBA code for Copy paste multiple tables skipping blank in to another worksheet

    Is it possible for you to post a sample workbook?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: VBA code for Copy paste multiple tables skipping blank in to another worksheet

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-prog...ml#post4199627
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 10-05-2015, 08:59 AM
  2. Copy Paste multiple tables from multiple sheets into Outlook email
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 12:21 PM
  3. Code NOT working properly - Copy/Paste Multiple Tables
    By Blackhawks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2014, 12:18 PM
  4. Replies: 1
    Last Post: 04-15-2013, 08:06 AM
  5. Macro to copy/paste tables from one worksheet into another
    By Coachwooten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 10:47 PM
  6. [SOLVED] Copy multiple worksheets data & paste into blank columns in summary worksheet
    By guest99999 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-21-2013, 09:56 AM
  7. [SOLVED] Copy entire row in one worksheet, paste in next blank row in another worksheet
    By dev111ski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 01:02 PM

Tags for this Thread

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