Macro to copy row based on cell value, then replace with other number

[SyrupDuck]

Hi All,

I have a (for me) complicated request.

For an inventory I would like to have rows/data palletised (1 row per pallet). However, i receive the data with multiple pallets in one line, and totals of units.

What i would like, is a macro to copy the entire row (article # etc) a number of times as the total amount of pallets. Below an example with 1 and 3 pallets. The 1 pallet has the correct pieces per pallet, but for the 3 pallets, it will be split according to the info available. I would like a popup message box to ask for manual input, but after it has been asked for the total pallets, the sum of the entire input should match the original field.

Below the table.

Pallets	Article#	Pieces	Other info
1	AAB	50	ABCD
3	ABB	500	DCBA

This should become the following table, in which for every line of the 3 pallets it copies, excel asks how many units are in the pallet.

Pallets	Article#	Pieces	Other info
1	AAB	50	ABCD
1	ABB	100	DCBA
1	ABB	100	DCBA
1	ABB	300	DCBA

Then after it is done with the 3 pallets, it will match the sum of the input with the original. Say the total was 500, and someone entered 100, 100 and 301, it should start over and/or mention it's incorrect.

Does anyone have any idea how to do this? :S

[SyrupDuck]

Does any have an (even partial) solution to this?

[AlphaFrog]

Try this...

Please Login or Register  to view this content.