Excel 2007 : Creating a Macro that will Copy Rows to new sheet based on text input

**diypirate** · 10-05-2011, 03:50 PM

Hello,

I apologize in advance for being a relative "newbie" to excel and more specifically to VBA and creating Macros. I have a projects database for the company I work for and need to be able to copy rows based on inserting an "x" into any of the three columns entitled "GreenBuilding," "HERS," or "T24".

I have been trying in vain for several hours and trying to apply others code to the file, unsuccessfully. Any help would be greatly appreciated.

Also, the file is attached.

**tlafferty** · 10-05-2011, 04:01 PM

Put this code in a blank module:

Please Login or Register  to view this content.

**GeneralDisarray** · 10-05-2011, 04:27 PM

shoot...removed mine

beaten to the punch again

your way is better anyway

**diypirate** · 10-10-2011, 02:52 PM

Thank you both for your help. The only problem that I still face is that the information when I run everything to be updated copies over twice. So, if project 4994 is in HERS and I add project 5001 then when I run everything the HERS page shows 4994 twice. Sorry, if that is confusing, I'm not to good at explaining these things.