How to Copy by Each Row not Overall, how's the logic?

Hi,

I have this condition. user define which data will be copied, by typing "YES", after typing it all, they'll push button "Input to database"

It's seem similar to my previous post http://www.excelforum.com/excel-gene...ml#post4305711

but it's totally different case.

the data will be copy & paste to designated table in other sheet. currently it copy by overall, here's the screenshot, code, and file

is there a way, to copy only row 10 & 14 to be paste into the table?

file download Copy based on condition with random row.xlsm

user defined which data will be copied... by type Yes, column I-L = B-E. and when user click input to database, data in I-L will be copy & paste to sheet Table.
NOTES : it must going through I-L first. and copy data from I-L, not B-E

Capture.JPG

the current result, K3 failed to detect the last FALSE in H14, because its just detect the first one.

tableResult.JPG

my code.... which copy data from I-L to Sheet Table

Please Login or Register  to view this content.

You don't have to use 3rd party file uploads, use this forums uploader.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

Originally Posted by davesexcel

You don't have to use 3rd party file uploads, use this forums uploader.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

Hi DavesExcel,

Thanks a lot for helping me... I've add the attachment in my first post, and

Here's my current code do after user click input database, it will copy cells (within red square)

CurrentCodeCopy.JPG CurrenttableResult.JPG


My expected result is, it will copy each red square, wherever the data checker say FALSE

expectedCodeCopy.JPG ExpectedtableResult.JPG

How to write the code then?

thanks so much for looking this case
Warm regards,

Adrian

In order for this to work correctly, you will have to make sure the table and last row are the same.

2-3-2016 6-07-37 AM.jpg

Run the code

Please Login or Register  to view this content.

The result ,

2-3-2016 6-08-19 AM.jpg

Find attached workbook

You don't have to quote the entire previous post, it just clutters your thread.

When finding the last row, if a table is involved, the code will find the last row of the table, not the last row that has a value in it. I just wanted to make sure you had no empty rows in your table.