XmasStar
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
Dnyan2001
62

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
XmasStar
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
XmasStar
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
Dnyan2001
62

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
XmasStar
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
Attached Files (Download Requires Membership)
File Type: jpg Screen-1 - customer database with current and deleted customers.JPG (79.4 KB, 271 views)
File Type: jpg Screen-2 - I have selected a middle row for deletion.JPG (80.5 KB, 106 views)
File Type: jpg Screen-3 - amended as last row to the second sheet -deleted customers.JPG (72.3 KB, 81 views)

Dnyan2001
62

Hi, Check the attached excel file I think your query will be resolved. Regards Dnyan
From United Kingdom
Attached Files (Download Requires Membership)
File Type: xls Macro for Move Row to another Worksheet.xls (33.0 KB, 723 views)

XmasStar
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
mohan308
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
Dnyan2001
62

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
Attached Files (Download Requires Membership)
File Type: xls Vlookup.xls (29.0 KB, 263 views)

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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.