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.

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.

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.