Search the Community

I have column B with 200 rows of true / false I am trying to write a macro that will search column B from the top and when it finds the first true it will copy the contents from that row in column A and paste them to D1 Then I want to do the same thing in D2 but searching for the second true then in D3 searching for the third true. e.g.If the first True is in cell B50 then I want cell D1 to display the contents of cell A50 If the second True is further down say in B75 I want cell D2 to display the contents of cell A75 If the third True is in cell B150 then I want cell D3 to display the c

Sorry to bother you guys again but I’ve spent hours on this with no success. I have some excel 2010 files containing self signed macros and want my mum to be able to use them on her new win 7 office 2010 computer. I tried to import the certificate but it says it can’t import it because the certificate is not trusted. There is also a message that says the certificate doesn’t have a key. Not sure if this is anything to do with it but it works on my laptop without the key. I have Googled this and followed Microsoft instructions to export and import the certificate and I have done this throug