Copy down cells with SKU IDs in a Bill-of-Material

**anasman** · 09-11-2017, 04:07 PM

Excel Challenge v1 00.png
I need to create a macro that copies down SKU IDs in Column A, until the next SKU. Then continue to the end of the list

**davesexcel** · 09-11-2017, 04:41 PM

Could you supply more detail?

**MarvinP** · 09-11-2017, 04:45 PM

Hi Anasman and welcome to the forum,

Excel has a new Add-In Tool called Power Query and you can install it from:
https://www.microsoft.com/en-us/down...5-46db140afecd

This new tool has the feature you need called "Fill Down"
https://www.excelcampus.com/library/...s-power-query/

Re: Copy down cells with SKU IDs in a Bill-of-Material