| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for data and bring it up in another worksheet
I have built a quotation system. Each quotation is saved into another
workheet after it has been produced. I need a way to search for a quotation, and then to bring it back up in the original worksheet. This search could be by surname, date, etc, however, I have no idea where to start with the coding. Thankyou for your time. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search for data and bring it up in another worksheet
How is your quote structured? i.e. Does it have a unique quote number,
customer account number, vendor code? What are the data fields and are they constant? "flymeoutofhere" wrote: I have built a quotation system. Each quotation is saved into another workheet after it has been produced. I need a way to search for a quotation, and then to bring it back up in the original worksheet. This search could be by surname, date, etc, however, I have no idea where to start with the coding. Thankyou for your time. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search for data and bring it up in another worksheet
Thanks for your reply
I haven't added a quote number, however, can do so if neccessary. This would obviously make each quote unique. The data fields are pretty standard; name, address, telephone, etc. Thanks "JLGWhiz" wrote: How is your quote structured? i.e. Does it have a unique quote number, customer account number, vendor code? What are the data fields and are they constant? "flymeoutofhere" wrote: I have built a quotation system. Each quotation is saved into another workheet after it has been produced. I need a way to search for a quotation, and then to bring it back up in the original worksheet. This search could be by surname, date, etc, however, I have no idea where to start with the coding. Thankyou for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use cell data for a web search & bring back in the results? | Excel Worksheet Functions | |||
| Search one worksheet to pull data into another worksheet | Excel Worksheet Functions | |||
| bring in data from one worksheet to another | Excel Worksheet Functions | |||
| How do I search for data in a large worksheet? | Excel Discussion (Misc queries) | |||
| Search for data in a column bring all related items in other colum | New Users to Excel | |||
Linear Mode
