Hi all,
I'm stuck on the following. I have a dataset which includes, amongst others, a date column, customer and number of pallets delivered. However, I would like to redistribute rows based on the value in pallets delivered column (column K); if this value is higher than 26, these specific rows should be redistributed into new rows, where the values in all other columns remain the same, except for column K. For example; cell K2 contains '59', new rows K3, K4 and K5 should state 26, 26, 7 respectively.
I am not even sure if this a realistic option. If you have other suggestions, please let me know.
Thanks in advance,
Rob
ps. I'm not a VBA expert, but I know how to implement codes.
I'm stuck on the following. I have a dataset which includes, amongst others, a date column, customer and number of pallets delivered. However, I would like to redistribute rows based on the value in pallets delivered column (column K); if this value is higher than 26, these specific rows should be redistributed into new rows, where the values in all other columns remain the same, except for column K. For example; cell K2 contains '59', new rows K3, K4 and K5 should state 26, 26, 7 respectively.
I am not even sure if this a realistic option. If you have other suggestions, please let me know.
Thanks in advance,
Rob
ps. I'm not a VBA expert, but I know how to implement codes.