banjoflanjo
New Member
- Joined
- Mar 20, 2008
- Messages
- 44
Hi,
I have created a database which consists of 7 different tabs which need to be populated with entries. As such I have created a form for inserting new entries (each entry needs to be added to all 7 tabs). Each database range is named sheet1 - sheet7.
What I need is another form for deleting entries eg. enter the database reference number in cell A1, start a macro that finds this entry in all 7 named ranges and deletes the entire row that it finds it on.
Can anyone help with the code that I need for this?
Thanks
Banjoflanjo
I have created a database which consists of 7 different tabs which need to be populated with entries. As such I have created a form for inserting new entries (each entry needs to be added to all 7 tabs). Each database range is named sheet1 - sheet7.
What I need is another form for deleting entries eg. enter the database reference number in cell A1, start a macro that finds this entry in all 7 named ranges and deletes the entire row that it finds it on.
Can anyone help with the code that I need for this?
Thanks
Banjoflanjo