Using VB to save data from an input sheet to a record sheet

**JSCR01** · 01-31-2010, 05:42 PM

Ok, So here is my problem
My Spreadsheet resembles a booking system, and when the user enters the data of a booking with will show up in text format at the bottom in a on screen Receipt.
What i want to do, is when the user presses save, it need to save all the information on the on screen receipt to another sheet which will act as a data base.
I have attached the Spreadsheet.
Please help.

Note: The input sheet is where the data is inputted, and the Record sheet is where i want the data to be saved.
Also Attachment is Excel 2007 file

**JBeaucaire** · 01-31-2010, 10:11 PM

This should get you started. I used:

1) name ranges to defined the types of refreshments. Look in the Name Box to see the various categories added
2) qty columns to allow you to set how many of each thing is being ordered
3) Data Validation drop downs in the worksheet cells themselves instead of ActiveX controls, simpler, easier to maintain
4) FORM buttons instead of ActiveX buttons

You'll probably need to redesign the RECORDS sheet to allow slots to store types of refreshments and quantities, not sure what the purpose of the records file is, so wasn't sure how to suggest your changes. For now, the macro just puts in the "total" for refreshments.

Hopefully this will give you usable ideas.

**JSCR01** · 02-01-2010, 07:29 AM

Originally Posted by JBeaucaire

This should get you started. I used:

1) name ranges to defined the types of refreshments. Look in the Name Box to see the various categories added
2) qty columns to allow you to set how many of each thing is being ordered
3) Data Validation drop downs in the worksheet cells themselves instead of ActiveX controls, simpler, easier to maintain
4) FORM buttons instead of ActiveX buttons

You'll probably need to redesign the RECORDS sheet to allow slots to store types of refreshments and quantities, not sure what the purpose of the records file is, so wasn't sure how to suggest your changes. For now, the macro just puts in the "total" for refreshments.

Hopefully this will give you usable ideas.

Hi, Cheers i like how you redesigned it, I used the active X as my tutor said it needed to be "Advanced" But May I ask, is it possible to describe to me what the code is doing? As it woul help me understand and learn what is going, I dont want to be one of those people who just ask for help, not understanding what is going on :P

Thankyou
James

**JBeaucaire** · 02-01-2010, 01:02 PM

Comments added:

Please Login or Register  to view this content.

**JSCR01** · 02-01-2010, 01:23 PM

Originally Posted by JBeaucaire

Comments added:

Please Login or Register  to view this content.

Thankyou for the help JBeaucaire I've had a look at this and it's given me a lot of help, but i do have one more question, can you use macros or vb to make a button use the save as command?

**JBeaucaire** · 02-01-2010, 01:47 PM

Seems pointless. The SAVEAS is already a button on the File Menu.

...and please don't use the QUOTE button to do simple replies. Use the Quick Reply box below.