Excel Micro Query - Jpg Download

I have a customer database with general information like name, address, phone no, etc etc in excel 2007.
First sheet has the details of current customers.
Second sheet has the details of deleted/ terminated customers.

Now my query is
"i want to delete a record of customer details. When i select that row and press <del> key on the keyboard, that particular entire row should be deleted from the first sheet and automatically amended as the last row in the second sheet"

Someone suggested that it can be done by using Excel Macro / Micro functions. but i dont know how to go about it. Can anyone help me out in this matter.
Or any other solutions please.
16th February 2011 From India, Mumbai

Hi,
Click on View Menu.
Select last option of Macros.
Click on Record New Macro
You can give Macro Name then select This Work book and click ok.
After that you do what you want for e.g. delte or copy paste in second sheet.
After finished your work again
Click on View Menu.
Select last option of Macros.
Click on Stop Recording.
after that you can run macro whenever you want
for run macro Press: Alt F8 - and Click on Run
Check this If you have a query you attach your excel sheet then I will help you.
Regards
Dnyan
16th February 2011 From United Kingdom

Thanks Altaf for your reply.
As you said.. I filtered the data, selected the row and gave command delete. And then??? How you link the database?? But will it solve my query that is copying the data from first sheet to the second sheet..
We need both the sheets.. Current customers and deleted customers in our records.
17th February 2011 From India, Mumbai

Dnyan, Thanks for your reply.
Very nicely u explained how to use macros.
I did exactly as you told. Its showing me the current customers database(after deletion) .
But the solution that you gave is not giving my result. I need both the sheets in my records i.e. the current customers and deleted customers.
17th February 2011 From India, Mumbai

Hi Xmastar I cant give you excat how to you without viewing your excel sheet. If you attach this excel sheet then I can give you solution. Regards Dnyan
17th February 2011 From United Kingdom

i have attached the sample sheet of customer database ... and step by step instruction of what exactly i want to do..
Screen-1 : Customer database showing 2 sheets 'Current customers' and 'Deleted customers'.
Screen - 2 : any one row is selected for deletion in the first sheet Current customers.
Then <del> key from the keyboard or <delete> from the right click of mouse is selected. The entire row is deleted from the 'current customers' sheet.
Screen - 3 : The deleted row is amended as the last row in the second sheet "Deleted Customers" sheet.
I hope now my query is clear...
18th February 2011 From India, Mumbai

Attached Files (Download Requires Membership)

Screen-1 - customer database with current and deleted customers.JPG (79.4 KB, 270 views)

Screen-2 - I have selected a middle row for deletion.JPG (80.5 KB, 106 views)

Screen-3 - amended as last row to the second sheet -deleted customers.JPG (72.3 KB, 81 views)

Hi, Check the attached excel file I think your query will be resolved. Regards Dnyan
18th February 2011 From United Kingdom

Attached Files (Download Requires Membership)

Macro for Move Row to another Worksheet.xls (33.0 KB, 718 views)

Thanks Dnyan,
My query is solved 99%.
Why 1% not solved.... I wanted to capture the keyboard <DEL> key or mouse <delete> directly.
But no probs atleast by button [Delete] i can do the needful. So its fine with me..
Thanks a lot.
22nd February 2011 From India, Mumbai

Hi I have a requirement..If a row is deleted in one sheet ,the corresponding row should be automatically deleted from the second sheet....i am not able to find a solution..please help me
9th June 2011 From India, Madras

Hi Anita
Vlookup are use when there are big data in file and you have to search some information then you can use this Vlookup.
I have attached a excel file in that Vlookup sheet you can get information about Vlookup and in other sheet also you can check others formulas also
Still if you have any query ask me...........
9th June 2011 From United Kingdom

Attached Files (Download Requires Membership)

Vlookup.xls (29.0 KB, 261 views)