Copy data across multiple worksheets (based on three criteria)

[yunesm]

I have data on a worksheet (“Interface”) that I need to copy over 7 other tabs for analysis ("Module_1", "Module_2", "Module_3", "Module_4", "Module_5", "Module_6", "Module_7").

The linking Field on the Interface tab defines what row I need to paste the data to on Module 1-7.

The column headers are the same on both the interface and other tabs (“YES, NO, N/A, BLANKS, STANDARDS MET, STANDARDS NOT MET, NOT APPLICABLE”)

The tab is selected based on the row
Module 1 Medication Management
Module 2 Privacy
Module 3 Process
Module 4 Patient Safety
Module 5 Medical Records
Module 6 Infection Control
Module 7 Environment of Care

I’m trying to modify code written for a similar purpose with no luck. This is the code I'm trying to modify. I know I'm not on the right track yet. But this was the general idea I was going for...

Please Login or Register  to view this content.

Any help would be much appreciated.
Thanks!
Mike

[JBeaucaire]

Try this instead:

Please Login or Register  to view this content.

[yunesm]

Thanks you! It works great. I appreciate the help.
Thanks,
Mike

[tbrice]

I am attempting to consolidate multiple sheets of text data within the same workbook into a master sheet within the same workbook, automatically. The master sheet is to only pull in those rows that have "false" marked in column D (or have the check box depressed) and I would like to have this happen real time. All of the headers are the same, however the data on each tab is different. I have columns A-J and infinite rows.
I am more of a novice at macros, so I would need something I could copy paste. Any help would be great.

[protonLeah]

Welcome to the Forum tbrice,, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.