Autofill cells from previous cell/row data???

I'm not too sure how I needed to word the Title, so I apologize if it doesn't make sense.

Here is what I am trying to accomplish.

I have a living Excel file that is Linked to Access (not too sure this part actually matters at this point, just more-less info for you all).

I have 8 columns of data. In Column A, I have the Client Number. I would like to be able to auto-fill Columns B, D and F if the Client Number and following data has been filled in previously.

Make sense???

If A2 - F2 have previously been populated and I have the same Client # to add more data at the bottom, then when I type in the Client # and hit Enter, I would like Columns B, D, & F in that row to automatically populate.

Other information in Columns C, E, G & H will be C&P and/or manually entered. The file is sorted by Column C (oldest to newest).

I have attached a small version of my worksheet.

Thanks for any and all help.

Shane


PS...This is a shared document, so there are multiple users updating this sheet.

Perfect...thank you!