Repeat Key Field - Fill in the Blanks

[caffodcu]

There was a tip published a few years ago that was extremely useful for reformatting report data extracted to Excel, but I cannot trace it anywhere. I'm probably not using the right search criteria. I do remember it used the Name Box to achieve the desired result. What it does is fill in the blanks on key information.

Example:
The spreadsheet has 3 columns.
Column A = Product Group, B = Sub-Product, C = Price.
At a change of Product Group the first row has all three columns populated.
In subsequent rows the Product Group is blank.
I want to fill in the blanks in Column A with whatever is above it.

Thanks

Mick W

[VBA Noob]

See if links is what your after

http://www.contextures.com/xlVideos01.html#FillBlanks

http://www.contextures.com/xlDataEntry02.html

VBA Noob

[caffodcu]

That's it! There is also a macro available which is even better.

Thank you

Mick W