• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find and delete value in column then shift up cells (not row)


New Member
Hello Everyone,

How would you find a value in a column then delete it and shift the values up to eliminate the blank space? Without deleting an entire row since there's data to the side.

For example:
The value in Sheet1 [E5] = Product5
Column F on Sheet2 would remove Product 5 from F7:F and shift up values below the new blank cell to close the gap.

I hope I'm explaining this ok.

thanks for any help with this.


Excel Ninja
As a new member, You should reread Forum Rules
There You can find many useful hints for You:
Posting Rules & Etiquette
How to get the Best Results at Chandoo.org

... eg about cross-posting

Your previous thread:
Okay, it was ... different.
For this ... have You tried to use Macro Recorder?
... with that, You would get Your needed functionality
... if it won't change again.