Filling in blanks using VBA

[dembele2504]

Hi,

I have a (hopefully) fairly simple problem for some of you guys.

In my data, the A column is a product code. B through to L is other data related to that product. If the product code appears more than once (which is ok, because the data, such as location, may be different) then there are just empty cells below. I have used VBA to open this from a txt source in excel.

The below is directly copied from my excel sheet. The gaps are where the same product code should appear as above. So for example: "8190268" should appear a further three times below the top one. What is the cleanest way to achieve this please? Please bear in mind the sheet may contain a lot more rows than in this example and also will change on a daily basis when importing the updated version.

To clarify, I don't want any blanks in the A column, and any current blanks have beside them data relating to the product above. So I just want that product code to be in the blank cells.

Thanks in advance.

Product
8083958
8084248
8084518
8182038
8186058
8186078
8190268



8220048
8225848
8244288
8244398
8260708
8340948
6694948
7935598
7935608
7935618
7935648

7639038

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[alansidman]

If you load your worksheet into Power Query you can use the Fill function to fill down the empty cells with the data above. It is a one step feature in Power Query.

Here is the Mcode

Please Login or Register  to view this content.

See in my signature how to apply

[dembele2504]

Hi Greg,

Thank you so much for your time, this worked an absolute treat. Exactly what I needed.

[Greg M]

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M

[Fluff13]

Another option

Please Login or Register  to view this content.