PLEASE HELP ME !!! Making something like a shoping cart in

[golot]

Hi,

In Microsoft Excel 2000 how can I do a button that sends two or more cells (a product name, the price and more) from the sheet the button is in to another sheet. Something like a shoping cart when you click on a product and it sends to the cart what you click.
If you have something that will help me please mail it to me at: golot@dr.com

Is it possible making a program (maybe '.exe') that is converted from an Excel file. Its like ammmm, If I have a Excel file with calculations and other stuff, how can I make it into a program? Maybe someone nice that knows how to make it will do it?
Please help I really want to to this...

Thanks alot ! Run Asulin (a.k.a golot)

[golot]

Please somebody HELP !!!!!!!!!!!

[Ivan F Moala]

On 2002-05-21 05:45, golot wrote:
Hi,

In Microsoft Excel 2000 how can I do a button that sends two or more cells (a product name, the price and more) from the sheet the button is in to another sheet. Something like a shoping cart when you click on a product and it sends to the cart what you click.
If you have something that will help me please mail it to me at: golot@dr.com

Is it possible making a program (maybe '.exe') that is converted from an Excel file. Its like ammmm, If I have a Excel file with calculations and other stuff, how can I make it into a program? Maybe someone nice that knows how to make it will do it?
Please help I really want to to this...

Thanks alot ! Run Asulin (a.k.a golot)

Hi golot
The 2nd part of your Q, you cannot make excel
into an exe program, that runs seperately.
You will have to run any programing that you
do in excel from the excel application and
not as a standalone application.

1st part of your Q.
Need more info but basically if all you are
doing is copying from one sheet to another
then try turning on your macro recorder and
see what you get. From there on in you will
need to specify the ranges you copy from &
to to get this to work dynamically.

Come back to us when you have this setup
and the criterias for the Copy range, destination range, etc.

Just as an example have a look @ this setup

So that you are basically copying over to your sheet this sought of info ??

Microsoft Excel - Book2 ___Running: xl2000 : OS = Windows (32-bit) 4.10
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
E1 = Your Data To Copy
	A	B	C	D	E
1	Product Name	Price	Quantity	Cost	Your Data To Copy
2	ABC	$ 1.25	0	:alert('=C2*C2')> $ -
3	XYZ	$ 6.25	0	:alert('=C3*C3')> $ -
4	Twx	$100.00	0	:alert('=C4*C4')> $ -
5	12 Doz	$ 13.65	0	:alert('=C5*C5')> $ -
6	Guiness 12	$ 0.99	0	:alert('=C6*C6')> $ -
7	Guiness 13	$ 11.67	0	:alert('=C7*C7')> $ -
8	Guiness 14	$ 24.33	0	:alert('=C8*C8')> $ -
9	Guiness 15	$ 36.99	0	:alert('=C9*C9')> $ -
10	Guiness 16	$ 49.65	0	:alert('=C10*C10')> $ -
11	Guiness 17	$ 62.31	0	:alert('=C11*C11')> $ -
12	Guiness 18	$ 74.97	0	:alert('=C12*C12')> $ -
13	Guiness 19	$ 87.63	0	:alert('=C13*C13')> $ -
14	Guiness 20	$100.29	0	:alert('=C14*C14')> $ -
Sheet1

To see the formula in the cells just click on the cells hyperlink

The above image was automatically generated by [HtmlMaker V1.27]
If you want FREE SOFT, click here and Colo will email the file to you
This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo