Making records from captured cell data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cvach - 23 Jan 2006 19:39 GMT

I have created an Order Form in excel, and I am looking to capture the
values that are entered into the Order form such as Company, Location
#, ect., and record them as a record on another worksheet. Any body
know the code for something like that.

Reply to this Message

Ron de Bruin - 23 Jan 2006 19:46 GMT

Hi cvach

Try this page to copy to a database sheet
http://www.rondebruin.nl/copy1.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have created an Order Form in excel, and I am looking to capture the
> values that are entered into the Order form such as Company, Location
> #, ect., and record them as a record on another worksheet. Any body
> know the code for something like that.

Reply to this Message

cvach - 23 Jan 2006 20:27 GMT

I have tried several of these macros but without much success. I have
taken screen shots of the spreadsheets and I would like to know if I
could e-mail them to you for you to look at. I think the solution will
be simple but I can not seem to find it on my own

Reply to this Message

Ron de Bruin - 23 Jan 2006 20:29 GMT

Ok, send them to me private

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have tried several of these macros but without much success. I have
> taken screen shots of the spreadsheets and I would like to know if I
> could e-mail them to you for you to look at. I think the solution will
> be simple but I can not seem to find it on my own

Reply to this Message

Ron de Bruin - 24 Jan 2006 15:01 GMT

I have sent you an example private

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Ok, send them to me private
>
>>I have tried several of these macros but without much success. I have
>> taken screen shots of the spreadsheets and I would like to know if I
>> could e-mail them to you for you to look at. I think the solution will
>> be simple but I can not seem to find it on my own

Reply to this Message