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

**Daril_Ghiroza** · 11-25-2015, 07:55 AM

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.

**vichopalacios** · 11-27-2015, 02:25 PM

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

**vichopalacios** · 11-27-2015, 02:26 PM

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???

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Populate Table (Restricted Values)

Macro to populate a table based on a selection critieria

[SOLVED] How to populate a table based on the searched values in a pivoted table

Code/Macro to populate table based on user input.

Looking for Macro to Populate a Table Based on Date Ranges

Formula to Populate table based on 3 input values

Populate Table 1 based on values in Table 2

Bookmarks

Bookmarks

Posting Permissions