There are two things i wanna know and that is...
1)I have 3 worksheets(all in same book) one being User Deletion one
being User addition and the other being the User details. They all have
numbers...and what i want to do is make a macro that looks up the user
number inputted on the user deletion worksheet and delete the record
with that number on the User Details.... These images kidna explain
what i want....
[image: http://www.rabidpanda.co.uk/Dan/ex2.jpg]
And is to be looked up and deleted on....
[image: http://www.rabidpanda.co.uk/Dan/ex1.jpg]

Hopefully thats understood....
Right the second thing is....
2) I have a cell in the User Addition page which is User number... Now
i've tried formuleas to validate this cell so it does not work with any
numbers in the User details list. I allways seem to get it to either
i)Not allow me to use this forumlea ii)allows me to use the forumlea
but it wont let me input anything.....any help? thanks for your help.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements