Fill empty cell with cell from above based on ID in colum A

[djfscouse]

Hi,

Using excel 2003 I have rows that share the same ID in columnA but they have missing information in certain cells on that row and need the information from above cell for the matching ID in columnA.

I have attached an example of the data before and after the VBA would be applied.

Thanks for any help,

David

[JBeaucaire]

This should do it of the data set isn't too big:

Please Login or Register  to view this content.

[djfscouse]

Thanks for your help JBeaucaire but it seems to copy from above for every empty cell and is not so dependant on the ID in column A.

If the cell above is empty for the same ID in column A I would like that row to have the same cell below empty.

Any suggestions is appreciated.

Thanks

[JBeaucaire]

Try this then:

Please Login or Register  to view this content.

[djfscouse]

That's perfect, thank you very much for your help.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.