IF "x" appears in column c, then copy corresponding column b to another wksht

[Lmhteach]

Hi, I am new to this site and am looking for advice from what looks like a great group of people. My situation is this:
I am creating multiple worksheets, and would like to link information from one worksheet to another in certain situations (IF statement, I presume.....I was using DOS to do lengthy statements years ago).

If any cell in column C has an "X" in it in the first worksheet (Scope of Work), I would like the corresponding column B (description or text) to be copied into another existing worksheet (Bid Proposal). I may end up with 20 or so items that need to be copied to the other worksheet.

Any suggestions are much appreciated.

Thanks,

Lynn

[NickyC]

Hi
try this macro
I have asumed when you say copy the corresponding column B, you mean the corresponding cell in column B - let me know if not and I'll rework it

Please Login or Register  to view this content.

[WasWodge]

Another macro (I am assuming it is going in column A and you have headers in both sheets)

Please Login or Register  to view this content.

or formula

In Bid Proposal cell A2 (I am assuming it is going in column A and you have headers in both sheets)

Please Login or Register  to view this content.

Copy/Drag down

If needed
Select the column then copy-pastespecial-values.
Either...
Select the column again and filter on blanks, select the rows from Row2 past your data, delete then turn the filter off
or
In a blank column put

Please Login or Register  to view this content.

Copy/Drag down. select the column, filter by X select the rows from Row2 past your data, delete then turn the filter off

[Lmhteach]

Thank you, NickyC and WasWodge for your quick responses. As much as I'd love to have a better understanding of codes, I'm not there yet. But the formula worked like a charm! I was able to get the information needed into the other worksheet. I am a little confused about how to filter out the blank lines, but will take some more time later to try and figure it out. I really appreciate your help! Thanks!

[WasWodge]

little confused about how to filter out the blank lines

Select the column.

On your "Data" tab (virtually in the cente) there is a filter section, in that section there is a big filter icon. Click it.

You now have a dropdown arrow in the top cell of your data. Click it.

In the box that appears uncheck the Select all checkbox, at/near the bottom (you might need to scroll) there is a Blanks checkbox. Check it and click and click ok.

On your spreadsheet now select the entire rows from the second row until past the row number past where your data was.

Right click and select delete row.

Click the autofilter icon again.

DONE!