Cell info transfering to another workbook in sequencial order

Hello,

I am new at this Macro programing and need a little assistant.

This is what I'm trying to achieve from this batch print out.

A1 B1 C1 D1
Batch # Material 1 (kg) Material 2 (kg) Material 3 (L)
43 (150) (250) (5.0)

This is a batch print out and every single time the batch number changes, the material number changes, and it only prints out current batch line and delete the old batch line as soon as it gets new info. (i.e. for batch #44, the values from B1 to D1 will change while erasing the old data)

So, what I am trying to do is to write a Macro where for every batch increment It copies the materials info to a different work sheet and it continues to copy the new information one line after another as the batch number increases.

This is what I got so far and it isn't working and need help

Please Login or Register  to view this content.

This macro isn't working and at the same time I want to run this macro continuously rather than running it only once.

Welcome to the forum.

Please read the forum rules below and then edit you're post to include code tags and amend you're title

VBA Noob