VBA code to populate a table depending on values in another table

[Andrevictor]

Greetings to Superbrain. Please advise on the suitable VBA code. I have two tables. One (three colums) contains values TRUE / FALSE - results of status of checkboxes. Another column contains text and the third - numerical values. I want the code to go through the first table looking for TRUE value. When found, values in two adjacent cells of the same row ("Document #" and "$xxx") to be copied and placed to the uppermost empty row of the destination table. The aim is to populate the destination table only with selected (TRUE) values and leave no empty rows. Thank you in advance.

 

[Marc L]

​

Other ways exist when the data does not respect Excel rules …​

​

Attach at least the before state and the expected result, better to help than any screenshot …​

 

[My Aswer Is This]

Your subject Title says:

VBA code to populate a table depending on values in another table​

But then you said forget the Table it's not a Table

 

[Andrevictor]

​

Needs only 2 codelines with smart ranges with headers but it seems headers are missing ?​

Hi. My ranges are with fixed number of rows and colums. I cannot use "dynamic ranges". I can figure out how to VLOOKUP for certain value and copy Offset cell value to another place. My problem is that I do not want empty rows in the destination range. All new data must go to the uppermost empty row in the destination range. Please help.

 

[Andrevictor]

​

Other ways exist when the data does not respect Excel rules …​

​

Attach at least the before state and the expected result, better to help than any screenshot …​

Befre state: the source range is populated with TRUE/FALSE values assigned. The destination range is empty. After VBA code is executed, the values in two left columns of the source range that correspond to TRUE are copied and pasted to the destonation range row by row beginning from the top without leaving emty rows.

 

[Andrevictor]

Your subject Title says:

VBA code to populate a table depending on values in another table​

But then you said forget the Table it's not a Table

I called this a Table with the same meaning as a table in the paper book. It is not a "table" in Excel terms. These are just ranges of cells. I can rename the Worksheet: Master, if this helps.

 

[My Aswer Is This]

I called this a Table with the same meaning as a table in the paper book. It is not a "table" in Excel terms. These are just ranges of cells. I can rename the Worksheet: Master, if this helps.

table in the paper book
Paper book???
What is a paper book ?

 

[Andrevictor]

​

Other ways exist when the data does not respect Excel rules …​

​

Attach at least the before state and the expected result, better to help than any screenshot …​

Here is a screen capture of my actual work sheet. I do not want emty rows in the quotation area on the right.

 

[Andrevictor]

table in the paper book
Paper book???
What is a paper book ?

In the millenia past, people used to read from the paper sheets. Some of them were technical and contained printed tables with the data.