macro help - delete

[step_one]

I have over 5000 rows of data that contain blanks

I would like where there is a blank for the data to Delete > shift left

i.e.
A17:D17 are blanks F17:H17 contain data

so if A17:D17 are blanks, then move data from F17:H17 to A17:D17 (delete left)

i would like so it searchs for any blanks in column A:D and replaces it with data in column F:H

can someone pls help with a macro? thxing u in advance

pls see sample attached**

[Blake 7]

How about

Columns("A:Z").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft

This will move all values to the left where possible. it that what yiou are after?

[MarvinP]

Hi step_one,

No code is needed if you can find the GoTo Special Dialog.

1. Select the range A2:E5000 (where these blank cells are located)
2. With the range above selected click the GoTo Special Dialog and find BLANK
3. Click OK from the dialog above and all blanks are now selected in your selected range
4. Right Click on any of the blank selected cells and click on Delete.
5. Choose shift left and problem solved.

I hope this is what you wanted.

[Blake 7]

@ Marvin - I think the Macro is much easier should the excercise need repeating on a regular basis.

[MarvinP]

If the OP has never seen the VBA editor then it might be harder to teach them to insert a macro than do it manually a few times.

I looked at the forum and if it was the programming forum then I'd agree they wanted the VBA code. Because it was the Excel General, I gave my manual method.

[Blake 7]

I was just going by the title - Macro Help. Anyway, i thought of you today. I was messing around with dates in a PT and was moving thm up/down individualy to get tham into the right order. I was going to post but you werent online! next time! Cheers Marv

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[step_one]

thx u guys for the great help and the pointers!