Make a new Format with VBA based on the data

[bocah]

Hello,


I have a problem work with two different type of workbook, it is a bit time consuming if I do it with a manual typing or copy pasting.
Is the any Solution to copy data to a certain format with vba code.

Note:
the first format if Feedmaster## and the 2nd is the target (or copy to new worksheet in Feedmaster##)

 

[Peter_SSs]

1. In the first image, what does "Start with column 8" mean? Does it mean start with row 8?

2. I can not see how the values in the second image are obtained from the first image. Could you explain in words how the values in rows 2 and 3 are obtained from the first image?

3. To test any solution would require a helper to manually type out a lot of data and many possible helpers will not bother. Could you give the sample data and expected results again with XL2BB so that they can be easily copied for testing?

 

[bocah]

I'm sorrry,
yeah, the data started from row 8.
I want to make a new format like in "target" from the data in Feedmaster, the data from the Column B, C, D, dopy to a new format if there is a number in column E to M. but the new format included that type of FEED (PAKAN).

for example in row 8 there is the data AT02 GA01 21-Apr-22 630 ECO-5 630 ECO-7

UNIT	TANGGAL	RING	PAKAN	QTY
AT02	21/04/2022​	GA-01	ECO-5	630​
AT02	21/04/2022​	GA-01	ECO-7	630​

 

[Peter_SSs]

for example in row 8 there is the data AT02 GA01 21-Apr-22 630 ECO-5 630 ECO-7

So for row 8

1. Why does your results in post #1 give 300 for QTY but your result in post #3 give 630 for QTY
2. Why does your results in post #1 give ECO-7 for PAKAN but your result in post #3 give ECO-5 for PAKAN
3. Why does your result in post #1 give 2 for CAVL but your result in post #3 doesn't have anything for CAVL?

 

[bocah]

Im sorry for making a wrong number,
but the format is just like that, the number should be same with the first picture.

You can ignore about the CAVL, the values always same number

 

[bocah]

 

[Peter_SSs]

the format is just like that, the number should be same with the first picture.

I will ignore that since the last picture in post #6 now has two rows for GA-1, which makes more sense to me.

Now, what about this so I can test?

3. To test any solution would require a helper to manually type out a lot of data and many possible helpers will not bother. Could you give the sample data and expected results again with XL2BB so that they can be easily copied for testing?