Automatically Populate Fields
Hello, I am a moderate to proficient excel user but have never used VBA to do any programming. I am trying to create a spreadsheet to record purchase orders. I would like to be able to input a purchase number in one column and have other fields in the row automatically populate such as "account manager""salesrep", etc... (perhaps pulling from another sheet with data). Is there a way to do this with excel? Thank you. -- tqdinh22 ------------------------------------------------------------------------ tqdinh22's Profile: http://www.excelforum.com/member.php...o&userid=36453 View this thread: http://www.excelforum.com/showthread...hreadid=562138 |
Automatically Populate Fields
I would suggest looking at the help for event driven macros. In this case, you need the worksheet_change event with the code placed on the appropriate sheet code page in the VBA editor. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=562138 |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com