VBA insert new rows between rows based on criteria or cell value

[Yna26]

Hi All, in my worksheet i have 2 types of shipment numbers tbe-0000 and tbew-0000. These shipments can have from 1 to several products i.e. rows to be copied in my worksheet (Tracking data) from another worksheet (Shipment details) and I am looking for a code to identify the last tbe number in my worksheet which is let's say tbe-6655 and copy the tbe-6656 rows right below it, then tbe-6657 rows and so on, same way to work with tbew. The only way I managed to do it so far was to create new rows at the end of the entire table and copy data which looks too chaotic as I must mention the fact that first part of my table contains tbe numbers, then towards the bottom of the table right after last tbe starts the tbew. I also mention the fact that I don't always receive them in their numerical order i.e. if my last tbe was tbe-6655 and now I received tbe-6657 first, I would like the code to still be able to identify and insert rows from tbe-6657 right below last row of tbe-6655 until I get data on tbe-6656 which would then be copied in between tbe-6655 and tbe-6657. I hope it makes sense and Appreciate any help.

 

[Fluff]

Duplicate to: VBA to copy, format, drag down data from other workbooks

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.