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.

 

[My Aswer Is This]

Can you please assure me we are working with a Excel Table

A Excel Table is a range on a Excel Sheet.
And if we are working with a Table give me the exact name of both Tables and the sheet name where the Excel Table is.

Many folks say I'm working with a Table when they really mean a sheet.

 

[Andrevictor]

Hy. The Excel sheet is Sheet1. The tables can be named anyhow: TableFirst, Range1, Range2, etc. I simplified my real layout with this picture to get generic code.

 

[Marc L]

Hi,​

​

as a generic code can't be the same using ranges or using Excel tables and as 'superbrain' can't mean 'mind reader' …​

 

[My Aswer Is This]

Hy. The Excel sheet is Sheet1. The tables can be named anyhow: TableFirst, Range1, Range2, etc. I simplified my real layout with this picture to get generic code.

I asked:
give me the exact name of both Tables

Well I need you to create the Tables and enter the data in the One table so then script can move the data to the other Table. And I want a sheet name like "Master"
Sometimes when users say sheet1 does that mean Sheet(1) or sheet named "Sheet1"

 

[Andrevictor]

The sheet name is exactly Sheet1, and I am not going to rename it. Forget the "tables", it is a Ranges "$B$3:$D$8" and "$F$3:$G$8".

 

[Marc L]

​

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

 

[Andrevictor]

I take it that you understood my needs: copy lookup values and paste to the upper empty row in another place. My main aim is not to leave empty rows in the destination range. I did not work before with "smart ranges" and cannt say anything about their headers. My original worksheet does not have the headers above thedata ranges, but if you think that they are neccessary, I will create the headres. I just do not know how.

 

[My Aswer Is This]

The sheet name is exactly Sheet1, and I am not going to rename it. Forget the "tables", it is a Ranges "$B$3:$D$8" and "$F$3:$G$8".

I'm going to move on and let others here help you.

 

[Andrevictor]

You are very kind.