Array Function to shift rows to the right in a range

I would help on building an array function that shifts rows to right of a data range. The attached spreadsheet demonstrates my desire more clearly!

Thank you for your help.

Thanks for your help.

But is it possible if you can show me how this can be done using VBA please?

Thank you guys.

Instead of using "xlToRight", how can I project the results on a different range?

Which Range? This will send the results to a helper Sheet1.

Please Login or Register  to view this content.

Thank you.

You're welcome. Glad to help out. Hope it does what you require. If it does then please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.