Automatically Populate Fields

[tqdinh22]

Hello,

I am a moderate to proficient excel user but have never used VBA to d
any programming. I am trying to create a spreadsheet to recor
purchase orders. I would like to be able to input a purchase number i
one column and have other fields in the row automatically populate suc
as "account manager""salesrep", etc... (perhaps pulling from anothe
sheet with data). Is there a way to do this with excel?

Thank you

 

[mrice]

I would suggest looking at the help for event driven macros. In thi
case, you need the worksheet_change event with the code placed on th
appropriate sheet code page in the VBA editor