copy partial row to sheet 2 if row has true in column k???

December 1, 2015 at 06:29:11
Specs: Windows 7
hi guys. im quite a newbie at this sort of thing, and i was wondering if there is someone out there who can save my mental health by assisting me.

i have an excel file with three sheets.. 1 2 and 3

sheet 1 has raw data imported onto it.
sheet 2 filters and elaborates on that data, it has check boxes on it for selection of products.
now sheet 3 is where im struggling, im wanting to import half a row from sheet 2 if that row contains the word "true" (which is generated from a tick box) into sheet 3 and add new lines under it if another box is ticket.

does this make sense? if not i can send the excel file to show you.

See More: copy partial row to sheet 2 if row has true in column k???

Report •

December 2, 2015 at 05:33:24
It would help if we could see the spreadsheet. You can not attach files to posts in this forum, so if you could post the file to a share site, such as zippyshare, and then include the link in a post back here, we should be able to access it.

Just make sure that you don't use a share site that is going to ask us to register because odds are that we won't. Your goal is to make it as easy as possible for us to access the file.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question