excel saving customer information to other work sheet?

Question

hi

i have two work sheets on my excel system, one of them is for customer information entry, and other one is to save information there. i designled entry work sheet like a form and it has a save button , when i press save button i want the information on the cells to go to my customer worksheet , is there a way to do this without VBA

thank you

Answer 1

No
You can not do this without VBA
The main reason is the destination cells, these cells are not the same at every click on the Save button
Means, when you enter data in your form and click Save, it will go to other sheet say cells A4:D4
After thatn the second form you enter and click Save, it should go to cells A5:D5
So, Excel can not do it alone, you will need VBA

If you are interesting, I can do this, I love doing this

Enjoy my profile, I am the VBAXLMan

Answer 2

you may write an Excel macro which will extract each and each sheet one after the different and keep it as a clean report. in all possibility a million/2 an hour greater artwork than paying for an off-the-shelf answer, yet won't fee something. Why keep information in an Excel spreadsheet although? that's what databases are for. positioned it in get right of entry to. Richard

Answer 3

In Excel, you REALLY dont need to do anything. All cells always update, unless you have it set to manual recalc. Simply reference the other worksheet (or other external workbooks). You may need to use some NAME referencing instead of A1 (with or without $) or R1C1 to segment your customers out.

Sometimes these type of spreadsheets for data entry are better served using Access...or at least through a reference into Access...

If this doesn't make sense, email me with more details and I will try to help you over the weekend offline.