ExcelBanter - Cell's data fills out the rest of spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Cell's data fills out the rest of spreadsheet (https://www.excelbanter.com/excel-programming/450441-cells-data-fills-out-rest-spreadsheet.html)

rtour957

Cell's data fills out the rest of spreadsheet

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.

Mandeep Baluja

Cell's data fills out the rest of spreadsheet

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.

All times are GMT +1. The time now is 06:18 AM.