Help Pleeeeeeeeeeeeeeeeease :-(

[Gaztaag]

hello im new, my names Gary an im from coventry in england
im doing A(s)-Level ICT and currently working on a spreadsheet desig
for a business including order forms customer database etc. the classi
a-level ict project basically.

I have a catalogue page with the products and the cutomer chooses th
size of the product and how many they want etc. i want to create
button that the uer clicks that then inserrts this data they hav
chosen into the next available space on the order form worksheet, ho
would i do this? i probably sound really stupid but i
would really help me if you could assist me please

Gaz :

 

[Guest]

Some things you would need to learn how to do in order to accomplish this:
1. Record macros to copy and paste.
2. Write macros in VBA using conditions and Excel VBA constants to find the
end of a filled range (your order form).
3. Write macros that can sequence the macros you've created previously into
a workable command sequence.
4. Create a button to execute the sequence.
5. Learn not to abuse the volunteers who are here to help with problems.

I'd normally wish you good luck, but frankly, I don't really care.

-Allan
Another Ignorant Poster on the Excel Discussion Group

 

[Andy]

im doing A(s)-Level ICT and currently working on a spreadsheet design
for a business including order forms customer database etc. the classic
a-level ict project basically.

What's A(s)-Level ICT stand for? What's a classic a-level project?