# Copy data from 1 table to another if cell is filled

1. ## Copy data from 1 table to another if cell is filled

Hi All,
Im trying to get specific Row data from table 1 to table 2 IF column H on table 1 has been completed

Please point me in the right direction

2. ## Re: Copy data from 1 table to another if cell is filled

I3=COUNTIF(\$H\$3:\$H3,"<>"&"")*1

B15=INDEX(\$A\$2:\$I\$10,MATCH(\$A15,\$I\$2:\$I\$10,0),MATCH(B\$14,\$A\$2:\$J\$2,0)) and drag across.

See the attached file.

3. ## Re: Copy data from 1 table to another if cell is filled

This is excellent.
But is there a way to have the COUNTIF column skip a value of 0?

Seems to be including a value of 0 and i dont want this?

4. ## Re: Copy data from 1 table to another if cell is filled

Explain more.

Since in your file there are no items with a zero, in table 2.

5. ## Re: Copy data from 1 table to another if cell is filled

I changed the COUNTIF to reference the length column instead of the description

With Table 2 - when i filter it to only show lengths with a value greater than 0 the item column is not uniform (1,2,3,4,5,6 etc)

6. ## Re: Copy data from 1 table to another if cell is filled

I3 =if(or(\$d3="",\$d3=0),"",countif(\$h\$3:\$h3,"<>"&"")*1)

7. ## Re: Copy data from 1 table to another if cell is filled

The data is inconsistent. Why is ther PB04 in row 7, there is no other data in that row.

There are currently 1 users browsing this thread. (0 members and 1 guests)

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