Share via

Auto Fill Data between 2 cells

Anonymous
2023-05-29T23:17:15+00:00

I was wandering if its possible to auto fill a cell from another. For example I have a list of business names in cell 1 and need it to be a specific payment term in cell 2. Cell 2 has a drop down box option, however is it possible this cell automatically fills to the correct one by the business name put in cell 1?

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-10T23:44:18+00:00

    Hi, please let me know when a good time to do this is.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2023-06-12T22:41:10+00:00

    Yes, I'd like to give this a try please.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-05-30T02:46:47+00:00

    Hi Emily

    Re, "... Cell 2 has a drop-down box option, however, is it possible this cell automatically fills to the correct one by the business name put in cell 1?"

    I would suggest using the VLOOKUP() function, but this will require eliminating the drop-down list in Cell 2 since we can not simultaneously have a Formula and a Data Validation dropdown list in a cell.

    So, I'm afraid, we might only achieve that using a VBA code, plus some additional table creations

    Do let us know which way you want to go, so we can work on the solution.

    Regards

    Jeovany

    Was this answer helpful?

    0 comments