ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create a report and have a search funtion to find data (https://www.excelbanter.com/excel-discussion-misc-queries/203273-create-report-have-search-funtion-find-data.html)

JJ

create a report and have a search funtion to find data
 
like to create a report or form in either excel, word or access to use so I
can let other people find data by having a box that they can use ie: name of
person or house address

ShaneDevenshire

create a report and have a search funtion to find data
 
We need more details.

1. You could just press Ctrl F and have them enter the name or address and
let Excel, Word or Access find it.
2. In Excel you could turn on Data, Filter, Auto Filter and let them pick
from the drop down lists
3. In Access you can use various filters or queries.
--
Cheers,
Shane Devenshire


"JJ" wrote:

like to create a report or form in either excel, word or access to use so I
can let other people find data by having a box that they can use ie: name of
person or house address



All times are GMT +1. The time now is 10:42 PM.

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