M
Minna
Hi all and thanks for you 2 guys, who sent me replies to my message.
The links given weren't very helpful, as I would like to get direct
instructions to help me out with this problem. I am not very good with
Excel, so that's why the links to different MS Articles won't help. Is
there anyone, who can help me by giving me simple instructions like 1)
Do this and then do that, 2) press this and then press that.... etc.?
So here's my problem:
I am currently struggling with Excel macros and I have to say I don't
know anything about creating the macros.
So, here's the problem:
I have a worksheet x1 where I have a form for adding a new customer.
This form is not a real form. I have just used the normal worksheet.
Then I have a table in anothe worksheet x2 where I have all the
customer id's, names, addresses and so on.
I would need to have the x1 form to work the way that it automatically
gets the first available customer id to the cell D9 from the x2 table
(for the new customer).
Then, after entering the new customer details to the form x1 I have a
button, which should by pressing it, copy the customer names and
addresses to the correct cells in the table of sheet x2. Of course the
details should go to the same line, which indicates that new customer
id.
So, if the next available customer id is 8 and the row number is 9,
the details should be copied to that line number 9. And the next new
customer should get the next available customer id, 9 and the details
to be copied in line 10 etc.
Hopefully I have explained this clearly enough
Just to make sure that I am understood: I have two problems
1) How to automatically get always the next available Customer ID to a
certain cell (in this example D9)?
2) How to copy the new customer details to the correct cells depending
on the customer id and next available lines by pressing a button "Save
new customer details"?
Please email me if you need more information as I am really in a hurry
with this thing
Thanks for all the tips and help!
Rgds,
Minna
The links given weren't very helpful, as I would like to get direct
instructions to help me out with this problem. I am not very good with
Excel, so that's why the links to different MS Articles won't help. Is
there anyone, who can help me by giving me simple instructions like 1)
Do this and then do that, 2) press this and then press that.... etc.?
So here's my problem:
I am currently struggling with Excel macros and I have to say I don't
know anything about creating the macros.
So, here's the problem:
I have a worksheet x1 where I have a form for adding a new customer.
This form is not a real form. I have just used the normal worksheet.
Then I have a table in anothe worksheet x2 where I have all the
customer id's, names, addresses and so on.
I would need to have the x1 form to work the way that it automatically
gets the first available customer id to the cell D9 from the x2 table
(for the new customer).
Then, after entering the new customer details to the form x1 I have a
button, which should by pressing it, copy the customer names and
addresses to the correct cells in the table of sheet x2. Of course the
details should go to the same line, which indicates that new customer
id.
So, if the next available customer id is 8 and the row number is 9,
the details should be copied to that line number 9. And the next new
customer should get the next available customer id, 9 and the details
to be copied in line 10 etc.
Hopefully I have explained this clearly enough
Just to make sure that I am understood: I have two problems
1) How to automatically get always the next available Customer ID to a
certain cell (in this example D9)?
2) How to copy the new customer details to the correct cells depending
on the customer id and next available lines by pressing a button "Save
new customer details"?
Please email me if you need more information as I am really in a hurry
with this thing
Thanks for all the tips and help!
Rgds,
Minna