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 contents of cell A150 It doesn’t matter if there are more than 3 True's I only need to find the first 3 wherever they are in column B

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 through internet explorer and excel but it just won’t work. With her old XP office 2003 computer I just trusted the publisher but there isn’t an option to do that on her new one. I have checked that macros are set to be disabled unless signed by a trusted publisher but can you trust yourself as a publisher on win 7 office 2010.