When you are creating data forms - e.g. Payroll Statements, use Excel's =VLOOKUP() function to populate the data fields.
You will save time and be sure that the latest changes in your data are reflected on your forms.
I invite you to visit my website - http://thecompanyrocks.com/excels
to view all of my Excel Training Videos.
@xxxstefanirrrr
I have several videos here on YouTube that show you how to do this. Search on my YouTube Channel for "Data Validation" - Pick from a List.
If you send me a YouTube Message (rather than a comment) I can direct you to the appropriate videos for this.
Danny Rocks
The Company Rocks
DannyRocksExcels 6 days ago
Hi danny. Quick question. We do our invoices manually in excel and we would like to input our customers info in a way that when we enter the customer info it will come from a drop down list and we can just click it. Please help.
xxxstefanirrrr 6 days ago
@snowwarrier20
Thank you for the compliment.
Danny Rocks
The Company Rocks
DannyRocksExcels 5 months ago
nicely explained..
snowwarrier20 5 months ago