Serious help with VBA and Macros!

[cbeckstrom]

Hi everyone,

I am new to this forum and VERY new to Excel VBA, macros, programming, etc.

I am trying to create a worksheet that generates a report upon the press of a button. It needs to enter the information in a row based on the value of another cell in that row (i.e. If I place an "X" in cell in H5 on sheet1 then I need the information in cells A5, B5, D5, E5 &G5 from sheet1 entered into sheet2. This goes on for another 180 rows and if there is no X, then it needs to skip to the next row and so on. I would like to enter all info on sheet 1, then hit the button on the bottom of each column with the X's and have it generate a report on a different sheet for each column (column H, button1, info on sheet 2; column I, button 2, info on sheet 3...).

Does any of this make sense? I need some serious help and have attached a sample workbook. I have yet to create the templates for Columns I-N on sheet1 so if you could just help me create one report for column H on sheet 1. Any help would be appreciated because I am getting extremely frustrated trying to enter formula after formula!!! I decided to start all over and try out this forum instead I tried entering tags but it keeps saying that they are too long (more than 25 characters).....so I guess I could use some help with this too :/

Thanks,
CB

[Palmetto]

Here is a Serious hint: edit your thread title so that it precisely describes your thread/need and then the free help on this forum will work on providing a solution. Seriously - do read the forum rules or you will receive infractions.

[teylyn]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST