Automatically Populate Fields

  • Thread starter Thread starter tqdinh22
  • Start date Start date
T

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Populate Fields 1
Automatically gray out rows when a particular field is populated 4
Automatically gray out a row when a particular field is populated 1
compare 2 spreadsheets and automatically populate fields 1
Random Samples 1
automatic population of rows 1
VLookup, Dynamic Range or Something else 8
Selection of drop down list directs auto population of other cell 1

Back
Top