Copying rows to another sheet if X criteria is met.

[gmacmillan1982]

Hi, looking for some help, i'll try to be a little more clear.

I have a spreadsheet with a bunch of information, like a checklist. On Sheet 1, it lists all of the tasks to be done in columns A-G. Columns H-S are for different departments and if they are to do that task, there is an X in that column. What I'm trying to accomplish is to have a drop down on Sheet 2 that says the department name, and if there's an X in that column, I would like the entire row to be pasted onto Sheet 2, columns A-G. There are multiple rows that may need to be pasted onto another sheet. I have been working from another spreadsheet, but for the life of me, can't figure out what needs to be changed to get it to work properly. This is the code I've been using from another workbook.

Please Login or Register  to view this content.

[Glenn Kennedy]

Welcome (back) to the forum.

Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

Do not keep it a secret. We all are willing to give you our time, freely. However, some of us (especially me!!) get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

1) if you have cross-posted, and

2) the URL of the cross posts.

That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Pepe Le Mokko]

Hi
please note that with two posts you have managed to violate two forum rules, one about duplicate posting and one about cross posting.

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)