VBA Code to copy different data from one sheet to multiple sheets based on criteria

Hello,

I am very new to VBA code and would greatly appreciate any help you are able to offer. I have a master contacts workbook and would like the ability to add new contacts to sheet 1 and then, based on criteria that was entered in specific columns, have that data automatically be added to the additional appropriate sheets within the workbook. I would like the spreadsheet to auto-update and I would also like for only the first couple of columns for each row to be copied over to additional sheets.

I've attached an example spreadsheet. Eharwood_VBA code sample file.xlsx

I have columns for first name, last name, and contact info. Then there are columns that tag the individual as a member/non-member and based on participation in various committees there is a yes or no for each committee column.

For the first row of my example spreadsheet John Smith is a tagged as a member (per column H) and also a member of the Promotions committee (a yes in column K). Therefore, I would like the ability to have John Smith's information automatically added to the member sheet and also to the promotions sheet. I also only want to copy the info from columns A-G to each additional sheet in the workbook.

Based on extensive googling below is the code that I am attempting to use, but I receive an error message and I also feel like there is a much more efficient way to accomplish the same thing. Any suggestions and help are greatly appreciated!

Please Login or Register  to view this content.

Thank you,

Hi eharwood

Welcome to the Forum!!!

How many members will you have in the Master Sheet?

Hi eharwood

Try the Code in the attached. Please note, I've modified the Sheet Names of GRMCA Member and Non-Member Dropped the trailing "s"). This was done to make the Code less wieldy.

I've also added Data Validation to Columns H through L. CTRL + x will fire the Code.

Please Login or Register  to view this content.

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

Hi eharwood

The Code was written to accommodate the Sample File. I'd need to see what you'd be adding in order to modify the Code for this

If I wanted to add additional sheets or categories to the spreadsheet, how would I alter the code to include the additional tabs

Hi eharwood

If you're simply adding Yes/No questions the change appears rather simple...the new Column Heading needs to be the same as the new Sheet Name...

Please Login or Register  to view this content.

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.