BIG BIG HELP

[Lenny]

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]

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

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

[Lenny]

amber that would be a great help and no it doesn't have to be a csv file my
email is [email protected] 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
>
>

[Amber_D_Laws]

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 [email protected].

Good Luck,
Amber

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


>
>
> --
> 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
>
>[/color]

[Amber_D_Laws]

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:

[email protected]

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 [mailto:[email protected]]
Sent: Wednesday, February 01, 2006 3:58 PM
To: Amber D. Laws
Subject: RE: 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 [mailto:[email protected]]
Sent: 01 February 2006 21:55
To: Leigh Richards
Subject: RE: 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 [mailto:[email protected]]
Sent: Wednesday, February 01, 2006 3:29 PM
To: Amber D. Laws
Subject: RE: 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 [mailto:[email protected]]
Sent: 01 February 2006 16:58
To: Leigh Richards
Subject: RE: 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 [mailto:[email protected]]
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