ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Database interface. (https://www.excelbanter.com/excel-programming/434401-database-interface.html)

DutchKID6900

Database interface.
 
I have one database like worksheet with all our loan data. What I want is a
seperate worksheet were loan officers can pick thier name from a drop down
screen to display all thier loans. Then have the ability to change certain
cells that we allow access to. Then have those changes saved over into the
database like worksheet. Is there a simply way to do this or does it require
VBA?

ryguy7272

Database interface.
 
This should give you some ideas:
http://www.mediafire.com/?sharekey=0...75f6 e8ebb871

File is named 'FastFilter.xls'


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"DutchKID6900" wrote:

I have one database like worksheet with all our loan data. What I want is a
seperate worksheet were loan officers can pick thier name from a drop down
screen to display all thier loans. Then have the ability to change certain
cells that we allow access to. Then have those changes saved over into the
database like worksheet. Is there a simply way to do this or does it require
VBA?



All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com