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
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
Batch = 1
counter = 1
If Range("a1") = 43 + Batch Then
Batch = Batch + 1
Sheets("sheet2").Range("b" & counter).Paste
Sheets("sheet2").Range("c" & counter).Paste
Sheets("sheet2").Range("d" & counter).Paste
counter = counter + 1
This macro isn't working and at the same time I want to run this macro continuously rather than running it only once.