move and align cells

[crillux]

Hi all,

I have a task that I need to perform every now and then. And even though I normally find my ways around in Excel, I can't find a working solution for this one.

I have a list of features that I need to match with another list and place them on the same rows in my sheet. The attached file contains 2 worksheets where "Before" shows my normal input, and "Wanted" shows what I need to do.

Cols A-E contains info for the first set of features, cols G and H is the cells I want to move. Please note that sometimes the G and H columns contains info that are not present in A-E, and then I need to move those features around as well. An example is present at the bottom of the "Wanted" sheet.

I would really appreciate some help as this is taking me forever...

[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.

Also do not use abbreviated terms like Q, we know it is a question

[crillux]

I have changed the title. Sorry!

[royUK]

You still use unnecessary wording - macro or code

[crillux]

bump no response

[crillux]

new bump, no response.

Nobody out there who could help me on this one?

[shg]

See http://www.excelforum.com/excel-gene...ting-data.html

[crillux]

See http://www.excelforum.com/excel-gene...ting-data.html

Unfortunately I don't understand how to adopt this to get the result I want (see example). Anybody who can explain this a little more in details?

Thanks.

[shg]

See attached.

[crillux]

Thanks a million! I will save a lot of time on this one.