Excellover123
New Member
- Joined
- Jul 13, 2018
- Messages
- 37
Hi Message board. I'm looking for some help. I have a really horrible data set (stock board) that it 14 rows tall per sku and 39 columns wide per sku.
i need an sumif to loop through the data set and change the 5th row of each 14 row block of data, there is around 100 skus in the data set so around 1400 rows to loop. Is there away of having a macro to change at the interval of ever 5 rows & paste as value?
many thanks for your help.
gary.
EDIT: Also the sumif is going to be returning delivery information from another sheet in the same workbook, this will be based on the sku & date.
i need an sumif to loop through the data set and change the 5th row of each 14 row block of data, there is around 100 skus in the data set so around 1400 rows to loop. Is there away of having a macro to change at the interval of ever 5 rows & paste as value?
many thanks for your help.
gary.
EDIT: Also the sumif is going to be returning delivery information from another sheet in the same workbook, this will be based on the sku & date.
Last edited by a moderator:
