Select All Cells with a Specific Value to New Column

**Energy48** · 05-26-2020, 03:31 PM

My problem looks easy on a Windows Computer but I am finding it next to impossible to do the same on a Mac.

I am trying to move specific Values in an excel sheet to a single column. On a Windows computer all I did was do a Search, and in the OPTIONS dialogue, picked the Value I wanted, do SELECT ALL and Excel did its magic and job done.

The extra OPTIONS is missing in the Search function of Excel on the Mac. The best I could do was use Conditional Formatting to highlight the Text and that was it. I still can't copy and move formatted cell values to a new column.

Does anyone know how I can do this, which is straightforward on a PC, but not on the Macintosh?

I have attached the file I am working with. Highlighted is the number 11, which is what I am trying to SELECT ALL and move into a single column.

**alansidman** · 05-26-2020, 03:43 PM

Since you have posted in the VBA section. You used the term "move" so I have done a cut and paste.

Please Login or Register  to view this content.

**Energy48** · 05-26-2020, 04:14 PM

Thanks! It did move them to a new cell but it messed up the rows. It bumped them all up together, similar to applying a filter. What I am trying to do is move the Values to a new column and maintaining the row positions in the new column

**alansidman** · 05-26-2020, 04:49 PM

Ok. Amendment #1. It really helps if you explain in detail what you expect when you create your ask.

Please Login or Register  to view this content.

**Energy48** · 05-26-2020, 05:02 PM

BRILLIANT! It worked PERFECTLY! Thank you very much!

**alansidman** · 05-26-2020, 05:04 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Select All Cells with a Specific Value to New Column

LinkBack

Thread Tools

Rate This Thread

Display

Select All Cells with a Specific Value to New Column

Re: Select All Cells with a Specific Value to New Column

Re: Select All Cells with a Specific Value to New Column

Re: Select All Cells with a Specific Value to New Column

Re: Select All Cells with a Specific Value to New Column

Re: Select All Cells with a Specific Value to New Column

Thread Information

Users Browsing this Thread

Similar Threads

how to select only specific rows corresponding to a specific value in a column

[SOLVED] select last row containing specific text in column

[SOLVED] How to hide a column after select a other specific column?

[SOLVED] How to select all cells to the last cell in a specific column and copy values

Macro to select the last specific value in a column

[SOLVED] Select only cells with specific content and copy with next cells to the right

How to select a specific column with Excel VBA

Bookmarks

Bookmarks

Posting Permissions