I have some date I am trying to track and would like the sheet (labeled Takisha) to automatically delete the row from that sheet when a date is entered in column=AL (Closure Date) and move it the next open row in the sheet (Takisha Archives). I'm not real sure what the coding would look like for this, I haven't attempted to do anything like this before. If someone can provide some input it would be greatly appreciated
Daffy, can you provide an example workbook stripped of sensitive information? This would really help us in helping you.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Case Tracking.xls
Here's my worksheet
Anybody, that can help me with this problem??
Still need help with this problem, any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
TNDaffy 
Register To Reply
Bookmarks