Move cells in the same row to a new column based on another cells value in the same column

[RJREAD]

Hello, i am searching for a function that allows me to move two cells from their current position in a row to two other columns based off of the value of another cell in that row. I have seen many options to move data to another sheet but, not on the same row. Thank you for your help in advance.
Example would be: Move c1 and d1 to a1 and b1 based on the word in i1.

[vichopalacios]

@RJREAD
Functions cannot do what you want, you'll need to write a VBACode
Tell us if you need help on that

A user-defined function called by a formula in a worksheet cell cannot change the environment of Microsoft Excel. This means that such a function cannot do any of the following:
Insert, delete, or format cells on the spreadsheet.
Change another cell's value.
Move, rename, delete, or add sheets to a workbook.
Change any of the environment options, such as calculation mode or screen views.
Add names to a workbook.
Set properties or execute most methods.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[RJREAD]

Will this work for all rows in a column or just row specific? Thanks.

[JOHN H. DAVIS]

That was just for your example. This will check each cell in Column I.

Please Login or Register  to view this content.

[RJREAD]

Thanks all!

[JOHN H. DAVIS]

You're welcome. Glad to help out.