Hi i'm trying to find a solution to a problem i have i have a database of
some 25000 products in excel csv file. consists of a product code,
description, cost price and retail price
what i want to do is have some sort of form that when i enter a product code
the description cost and retail price comes up. i woulds need to enter many
and then work with the figures by incressing by percentage or price. at this
point i would need to click a button to send to another excel csv form
is it possible and can anyone help in getting me started
many thanks
lenny

Hi Lenny,

I have done something similar with the quote module I am building.
can send you the formulas I used in the cells to call up th
corresponding data, but I don't know that they will work in a .csv fil
format. Out of curiousity are you set on using the .csv format for bot
files?

Regards,
Ambeer :)

Lenny Wrote:
Hi i'm trying to find a solution to a problem i have i have a databas
of
some 25000 products in excel csv file. consists of a product code,
description, cost price and retail price
what i want to do is have some sort of form that when i enter a produc
code
the description cost and retail price comes up. i woulds need to ente
many
and then work with the figures by incressing by percentage or price. a
this
point i would need to click a button to send to another excel csv form
is it possible and can anyone help in getting me started
many thanks
lenn

--
Amber_D_Law
-----------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...fo&userid=3001
View this thread: http://www.excelforum.com/showthread.php?threadid=50695

amber that would be a great help and no it doesn't have to be a csv file my
email is we could always msn for 5 mins if you
can spare the time at some time i'll be free anytime

"Amber_D_Laws" wrote:


Hi Lenny,

I have done something similar with the quote module I am building. I
can send you the formulas I used in the cells to call up the
corresponding data, but I don't know that they will work in a .csv file
format. Out of curiousity are you set on using the .csv format for both
files?

Regards,
Ambeer :)

Lenny Wrote:
Hi i'm trying to find a solution to a problem i have i have a database
of
some 25000 products in excel csv file. consists of a product code,
description, cost price and retail price
what i want to do is have some sort of form that when i enter a product
code
the description cost and retail price comes up. i woulds need to enter
many
and then work with the figures by incressing by percentage or price. at
this
point i would need to click a button to send to another excel csv form
is it possible and can anyone help in getting me started
many thanks
lenny


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=506954

Great Lenny,

My fist suggestion is to convert any .csv files to .xls files. This
will allow you to access features not available to .csv files.

Next see the attached file, and let me know if you have any questions.
I have given you resouces for using a Index/Match formula. This was a
little tricky to me at first, but after you play around with it for
awhile it should all start to make sense. If not, feel free to email me
at .

Good Luck,
Amber :)

Lenny Wrote:
amber that would be a great help and no it doesn't have to be a csv file
my
email is we could always msn for 5 mins if
you
can spare the time at some time i'll be free anytime

"Amber_D_Laws" wrote:


Hi Lenny,

I have done something similar with the quote module I am building. I
can send you the formulas I used in the cells to call up the
corresponding data, but I don't know that they will work in a .csv
file
format. Out of curiousity are you set on using the .csv format for
both
files?

Regards,
Ambeer :)

Lenny Wrote:
Hi i'm trying to find a solution to a problem i have i have a
database
of
some 25000 products in excel csv file. consists of a product code,
description, cost price and retail price
what i want to do is have some sort of form that when i enter a
product
code
the description cost and retail price comes up. i woulds need to
enter
many
and then work with the figures by incressing by percentage or
price. at
this
point i would need to click a button to send to another excel csv
form
is it possible and can anyone help in getting me started
many thanks
lenny


--
Amber_D_Laws

------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread:
http://www.excelforum.com/showthread...hreadid=506954




+-------------------------------------------------------------------+
|Filename: Index & Match functions for Excel.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4290 |
+-------------------------------------------------------------------+

--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=506954

Please see the emails below. I hope someone can help, and take over
where I left off. I tried to include Lenny's file, but it won't let me
upload an excel file. If you need to see the file, please contact Lenny
directly at:



Good Luck Lenny! :)

Yeah, just saw that. Somehow, I am not seeing what you are meaning. I
have posted what you have so far (as an attachment), and these emails
to the forum under the tread you started. I really am not an expert,
but I am sure someone there will be able to help on your next phase of
development.

Good Luck,

Amber D. Laws, PMA
STL Mobile

-----Original Message-----
From: Leigh Richards ]
Sent: Wednesday, February 01, 2006 3:58 PM
To: Amber D. Laws
Subject: BIG HELP

The file is attached

Leigh Richards

The Refill Centre Ltd

Tel: 0845 23 015 23
Fax: 0121 742 7738
Mob:07876 706293

-----Original Message-----
From: Amber D. Laws ]
Sent: 01 February 2006 21:55
To: Leigh Richards
Subject: BIG HELP

No problem with the mumbling.

I would put the source data into a separate workbook that is not ever
opened. This is the case with my code module which draws its data from
a fee schedule. As to the other part about one cell and stacking up, I
am not quite sure what you mean. I have learned however that anything
is possible with Excel; it is just a matter of using the right tools.
Can you send me the file? I can take a look if you give me specific
examples, and see what I can come up with.

Talk to you soon,
Amber D. Laws, PMA
STL Mobile

-----Original Message-----
From: Leigh Richards ]
Sent: Wednesday, February 01, 2006 3:29 PM
To: Amber D. Laws
Subject: BIG HELP

Hi Amber
Thanks for the help you pushed me in the right direction
I have achieved my basic goal but is there now a way of only inputting
the code in one cell and so the data just stacks up underneath each
other
Can I also hide the source data
Or would it be better to have the source data on another workbook that
never gets opened and the data I need just comes across on some kind of
form

Sorry for mumbling

Many thanks

Leigh Richards

Mob:07876 706293

-----Original Message-----
From: Amber D. Laws ]
Sent: 01 February 2006 16:58
To: Leigh Richards
Subject: BIG HELP

You are most welcome Leigh. Lots of luck, and keep in touch.

Amber D. Laws, PMA
STL Mobile

-----Original Message-----
From: Leigh Richards ]
Sent: Wednesday, February 01, 2006 10:19 AM
To: Amber D. Laws
Subject: BIG HELP

Thanks amber

I’m sure I will be touch in the near future but for the mean time I’ll
have a go at sorting it with you formula

Many thanks

Leigh Richards

Mob:07876 706293


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=506954