BIG BIG HELP

[Guest]

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.
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

 

[Guest]

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

 

[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 (e-mail address removed).

Good Luck,
Amber

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

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

 

[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:

(e-mail address removed)

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