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