Hi
The attached spreadsheets shows three kits (KIT001, 002 & 003 in column A) with different amounts of components listed below them.
I'm trying to think of a way to update column B with the KIT number for the 'component' rows. So cells B3-B5 populated with KIT0001 and so on...
Any ideas?
Many thanks in advance!
Tom
Bookmarks