VBA Formula to "Move" Cells Containing Specific Text

[financeanalyst]

Hello,

I'm hoping to get a little help in writing a VBA formula to move some data in my spreadsheet to a specific column. To be exact, I have a spreadsheet in which my columns AA - AT contain URL links to some websources I've used in research. I'm trying to get any of the cells with SEC sources, or that contain the text "sec.gov", to move to my "Official Sources" column (AW).


Does anyone know if this is possible? Greatly appreciate the help!

[Olly]

Question: if multiple matches are found, which value should be written to AW? The first match? All matches concatenated (with a delimiter) ? If no matches found, leave AW blank?

[JOHN H. DAVIS]

If there aren't any circumstances where there may be more than one match then this may help.

Please Login or Register  to view this content.

[financeanalyst]

Good point, I hadn't thought about that. If there are multiple matches, than I would say the cell that contains "sec.gov" and is furtherst to the right. And then if no matches, leave the cell blank

[Olly]

Okay, then try:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[financeanalyst]

That works! Sorry for the delay, took me some time to figure out how to integrate that into my last formula. Is working perfectly! Thanks so much for the help with this, it's going to save a lot of time!

[financeanalyst]

Just posted a new thread in case either of you are available for a little help.....