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.
From India, Mumbai
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.
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
From United Kingdom
62Click 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
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.
From India, Mumbai
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.
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.
From India, Mumbai
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.
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
From United Kingdom
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...
From India, Mumbai
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...
From India, Mumbai
Hi, Check the attached excel file I think your query will be resolved. Regards Dnyan
From United Kingdom
From United Kingdom
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.
From India, Mumbai
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.
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
From India, Madras
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...........
From United Kingdom
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...........
From United Kingdom
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls