I have a list of active clients and want it to stay active only. When the client is "discharged" from the company, I want to add in the date and have the entire row automatically moved or at least copied to the discharged sheet. I also want the discharges to be in order of date. I am including attachment to give a visual. Might be an easy fix, but beyond me.
Thank you in advance!
Current Census of Active Patients (Wichita).xlsx
Right click on the "Active" sheet and copy this code
Add dates in column F and check sheet "Discharged".
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I spoke too soon. The correct row moves but it messes up somehow. I have things in row 2 and the code jumps the the discharged info into row 2. I know it is a small detail but makes all the difference to me.
Ok, which is the column that has data in row2?
Hi,
I have the followfing that is similar to what you are looking for:
In mine, I have a "to Do List" (sheet 1) and column 1 is a drop down (or can be manually filled). Anyhow, when "Done" is selected, the entire line is moved to another sheet "completed"Please Login or Register to view this content.
Maybe this will help if you change the respective values in the code...
Last edited by arlu1201; 07-25-2012 at 02:28 PM.
Tcy,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
ARLU:
I want row 2 on "discharged" to mirror row 2 on "active". When I put the data in it throws it to the bottom of the page. Also, when it brings the info to the "discharged" page it still appears in the "active" sheet. Is there any way to remedy this? It also, looks like it is kind of stuck between pages. Sorry to be a pain, I just can't do any of this myself.
Thanks for your time and patience!
---------- Post added at 02:25 PM ---------- Previous post was at 02:11 PM ----------
Thanks tcy, for whatever reason it doesn't work for me, but I appreciate the time and effort of trying to help.
Except for the fact that the row didnt get deleted from the Active sheet, did the code work otherwise in copying the data from the Active sheet to Discharged?
Arlu,
That seems to be it, except for not letting row 2 enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks