Data transfer

[kesh123]

Hi,

I have a task which requires me to transfer data from one sheet to another, but the sequence is different.
Layout is the same, but the data in sheet from which I need to transfer, is messy, it has old entries. The newer ones were added to the bottom.
I''ve got over 15000 rows to copy over in different places, so I figure out that would take me a week.

I was wondering if it would be possible to achieve desired result with VBA.

I've tried formulas but failed.

Example attached.
Could anyone advise?

Thank in advance,
Matt.

EDIT:
Mr Excel forum link:
https://www.mrexcel.com/forum/excel-...ent-sheet.html

[kesh123]

Sorry, I've changed my example a bit so You would have a better understanding of my problem.

Attached.

[kesh123]

This almost does the trick:

Please Login or Register  to view this content.

It takes the value (description) from the bottom just like I would like, but I need it to appear in the first location in Main!, and I need it to move a row and execute until all 3 rows filled in Main! sheet.
BTW. Main locations do not need to have ABC if that would make things easier. To execute this command I've erased ABC, which I could easily erase/add back again with formulas, so no issue there.

Another example attached, after that code had been executed, and ABCs removed.

Thanks,
Matt.

[kesh123]

Please help

[kesh123]

I am very sorry for posting under myself guys, but this is important to me, I need to bring my topic to the top so people could see it.

[AliGW]

It's fine to bump your thread, however, please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not based on your need for urgency. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

From the forum rules (link in the main menu above):

• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

[kesh123]

Hi Ali,

Thank You for that, I understand.
I just wanted to make sure that people could see it

Im not trying to be annoying, but Im the kind of person that gets excited quickly and cannot wait, and excel scripting is quite exciting for me, however lame it sounds

Regardless, thanks for everything

[Marc L]

Hi !

Post an expected result workbook according to a before workbook, it may be easier to help.

As the better initial explanation and attachment, the better & quicker solution …

[kesh123]

Hi Marc,

Thanks for Your post.

It's all there, look at Desired result in column C.

It was quite difficult for me to explain, so I've included desired result in column C in all my attachments, because I believe it's easier to understand the problem this way.

Anything else I could do, let me know

[Arkadi]

I don't get the logic... row 2 in book2 Main says Data!B2, yet that result you have in Main!B3 not B2...
Main!B5 says in Col C that it is Data!B5, yet the text is from B7?

It is also not clear why you are connecting them as you are, unless you want the Description from the same row in sheet "Data" IF and ONLY IF, the location number matches between the 2 sheets in that particular row?

[kesh123]

Hi Arkadi,

Sorry for the confusion, You've must have looked at the last book I've attached, which contains result of the macro I've got.

I attached before & after books, please see, hope that this will clear out the confusion.

[dominicb]

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

[kesh123]

OK i was not trying to hide it

I was not aware that this is so important

If anyone's interested in that matter please follow this link:
https://www.mrexcel.com/forum/excel-...ent-sheet.html

[kesh123]

bring up my post

[kesh123]

Issue solved on MrExcel please follow the link in the first post if You need it.
Thanks