Select particular value and insert to right x amount of cells

**coach.32** · 02-22-2024, 09:37 PM

In the attached workbook I would like to select all the 1's in column A and then insert those cells to the right 3 cells.
I tried to record a macro and look at the code but it doesn't show me the value I'm using or the number of cells to insert.
I can't just sort the column in numerical order because the values need to remain in the rows that they are.
The desired outcome is in G1:K15.
Just to add to the query, is it possible to have a pop up box asking what value I would like to select all of?

**DJunqueira** · 02-22-2024, 10:04 PM

As for a formula you could do this.

Formula:

Please Login or Register  to view this content.

**Artik** · 02-22-2024, 11:23 PM

Originally Posted by coach.32

I can't just sort the column in numerical order because the values need to remain in the rows that they are.

Try it out. Using column sorting:

Please Login or Register  to view this content.

Artik

**mjr veverka** · 02-22-2024, 11:31 PM

For numbers ...

Please Login or Register  to view this content.

**jolivanes** · 02-22-2024, 11:41 PM

See attached
Allow macros to be used.

**coach.32** · 02-22-2024, 11:42 PM

Thank you. This is perfect.

**coach.32** · 02-22-2024, 11:45 PM

I never thought you could use formulas. Thank you so much. Something else I have learnt from.
Thank you for all the options shown, it has definitely broadened my knowledge.

**DJunqueira** · 02-23-2024, 06:40 AM

Tks for the feedback, glad to help you to expand your knowledge.

Select particular value and insert to right x amount of cells

LinkBack

Thread Tools

Rate This Thread

Display

Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Re: Select particular value and insert to right x amount of cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] question about coding to select fixed amount of columns but variable amount of rows

Insert X amount of cells

[SOLVED] Select cells, insert new row, move rest of table down

Select only filled cells in column to use insert command

[SOLVED] VBA Randomly Select m amount from n amount of data, where m<n

Select cells without formula & insert different value

Macro to select fixed amount of cells to the right and left

Bookmarks

Bookmarks

Posting Permissions