+ Reply to Thread
Results 1 to 3 of 3

Finding a macro that will populate a table from another table based on a columns values

  1. #1
    Registered User
    Join Date
    11-24-2015
    Location
    South Wales, England
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Finding a macro that will populate a table from another table based on a columns values

    Hi, I am trying to figgure out how to transfer some Data from one table into another based on the cell contents...

    I have Sheet 1 which contains all of my raw data and i want to populate Sheet 2 based on if the values in 'Sheet 2 column T' are > 0.

    The problem that i seem to be having is whenever i use an IF formula i find that the rows where the 'Sheet 1 Column T' are <=0 are still being populated but are returning the "False" part of the IF formula where instead i want it to skip to the next one that is true.

    So IF a row in 'Sheet 1 Column T' >0 then in Sheet 2 i would like the data transfered from their respective sheet 1 columns to their respective sheet 2 columns as below:

    Sheet 2
    A B C D E F G H I J K L
    Sheet 1
    C A K L M N O P Q R S T

    If this is possible any help would be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    453

    Re: Finding a macro that will populate a table from another table based on a columns value

    The first par of your problem is possible to do with a simple code:
    -. select the rows where T>0 and transfer data to sheet2

    to their respective sheet 2 columns as below:

    Sheet 2
    A B C D E F G H I J K L
    Sheet 1
    C A K L M N O P Q R S T


    .....??? you mean that :
    .-the value in column A goes to col C,
    .-the value in column B goes to col A,
    .-the value in column C goes to col K,
    etc
    Barriers are there for those who don't want to dream

  3. #3
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    453

    Re: Finding a macro that will populate a table from another table based on a columns value

    The first par of your problem is possible to do with a simple code:
    -. select the rows where T>0 and transfer data to sheet2

    to their respective sheet 2 columns as below:

    Sheet 2
    A B C D E F G H I J K L
    Sheet 1
    C A K L M N O P Q R S T


    .....??? you mean that :
    .-the value in column A goes to col C,
    .-the value in column B goes to col A,
    .-the value in column C goes to col K,
    etc
    or something like that???

+ 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 Populate Table (Restricted Values)
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2014, 01:44 AM
  2. Macro to populate a table based on a selection critieria
    By jay170878 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2012, 09:56 AM
  3. [SOLVED] How to populate a table based on the searched values in a pivoted table
    By Kausty88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2012, 06:11 AM
  4. Code/Macro to populate table based on user input.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-08-2011, 07:50 AM
  5. Looking for Macro to Populate a Table Based on Date Ranges
    By RTM1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2010, 12:34 PM
  6. Formula to Populate table based on 3 input values
    By Senthilerp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-18-2009, 01:19 AM
  7. Populate Table 1 based on values in Table 2
    By Alan1981 in forum Excel General
    Replies: 5
    Last Post: 10-22-2007, 04:34 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