+ Reply to Thread
Results 1 to 4 of 4

copy multiple tables from sheet to two sheets based on lastrow value

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    680

    copy multiple tables from sheet to two sheets based on lastrow value

    hello
    I have many tables what I would if the table contains the last row in column g= 0 then copy to sheet "paid " and if doesn't contain 0 then copy to sheet "unpaid" with considering if the tables in sheets "sheet1" from any value in lastrow in column g to 0 then clear the tables from sheet "unpaid " and move to sheet "paid" I put the result into sheets paid & unpaid
    note : if is possible do that by worksheet change event is better
    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,086

    Re: copy multiple tables from sheet to two sheets based on lastrow value

    Put this at Sheet1

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    680

    Re: copy multiple tables from sheet to two sheets based on lastrow value

    thanks but I no know how your code works as I far if change the value in column k then it supposes copy to sheets paid or unpaid , right or wrong? it doesn't happened any thing !

  4. #4
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    680

    Re: copy multiple tables from sheet to two sheets based on lastrow value

    sorry BO-RY your code is awesome , my bad I have to change in column k to see the changes
    many thanks for the great code

+ 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] filter data from multiple sheets based on sheet name and brand
    By leap out in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 01-27-2021, 04:22 PM
  2. Copy of multiple pivot tables based on Pivotitem to new sheets
    By MCTWT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2018, 10:03 PM
  3. [SOLVED] Multiple Sheet Export to PDF, one sheet needs specific range based lastrow of data
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2018, 07:39 PM
  4. Autofill Data based off current sheet lastrow not first sheet lastrow
    By bcarroll76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2018, 06:26 PM
  5. [SOLVED] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  6. Replies: 9
    Last Post: 03-28-2017, 08:30 PM
  7. [SOLVED] VBA Code to copy different data from one sheet to multiple sheets based on criteria
    By eharwood in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-08-2014, 02:22 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