Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have an extensive list of clients with the demographics info and each client has its unique number. I send out a good portion of these clients via spreadsheet I compile monthly. Is it possible to type in the client number so the rest of the demographic info is filled in automatically? Drop down list is not an option due to the number of clients.
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Tuesday, November 18, 2014 7:19:11 AM UTC+5:30, rtour957 wrote:
I have an extensive list of clients with the demographics info and each client has its unique number. I send out a good portion of these clients via spreadsheet I compile monthly. Is it possible to type in the client number so the rest of the demographic info is filled in automatically? Drop down list is not an option due to the number of clients. -- rtour957 USe macros for the same. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a button that automatically fills out data | Excel Programming | |||
Data Validation-pick from dropdown and next cell auto fills in inf | Excel Worksheet Functions | |||
What happened to the stripe fills for data series in Excel 2007? | Charts and Charting in Excel | |||
entering 1 cell fills the worksheet | Excel Worksheet Functions | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) |