move rows between spreadsheets

[jlederman]

Hello,
We run reports from active directory to see user accounts that have not been logged into the network between 30 and 90 days. We have a few spreadsheets within a workbook (Investigate, Disable, Delete, No Action). All user accounts are imported into the investigate spreadsheet. What we would like to do is automatically take predecided accounts (service accounts that we do not log on to the network - only meant for services, etc) and move them from the investigate spreadsheet into the No Action spreadsheet. These accounts all start with svc. Generic accounts start with GEN and so on.... Is this possible to do with a macro??

[yawnzzzz]

This sounds pretty simple to do. It might be easier if you give us an example, so I'd recommend creating a duplicate of this workbook and replacing all the actual user data with an example.

[jlederman]

I hope this sheds some light on what I want to do....we have several factors involved but if you could start me on the right track we can tweak as we see fit...thanks for the help in advance!

[boilerrwr]

I actually have a similar issue that I do not know how to write the VBA to do it. In my workbook there is the home page, 'Kent - All,' that the person will fill in their jobs. At the far right of the page there is a column for Active-A, Pending-P, Won-W and Lost-L. I am wishing so that once they fill out the job information and put the appropriate letter that it would populate that line in the appropriate page. So in my example the "white house" project, since it says "w" the whole line would populate in the won spreadsheet. and then if the letter changes the information moves to the appropriate page. I found a way to copy the line, cell by cell, into the appropriate page, but I was hoping to find a way to have it fill in from the top available row down.

Same here, if someone can give me a start on how to get it that would be much appreciated.

Thank you!

[Charles]

Hi,


Click the button "Click"
It should move the data to the sheets you requested.

[jlederman]

Charles,
That is exactly what I needed! However, it is pasting multiple copies of the same accounts to the NO ACTION sheet.

[jlederman]

Charles,
I take that back....it did work!! I am not sure what I did the first time but I closed it and then reopened and it worked like a charm!! Thanks alot for your time and effort in this! You have saved us hours a month with this!! I appreciate your help!!

[jlederman]

I have ran the macro against our real data and found that the original rows from the Investigate sheet are not being removed. Can you modify the macro to make this happen??

[jlederman]

Sorry for the multiple posts but I tried adding another command in the macro to include accounts that end with "bc" but nothing happens. Any advice??

[Charles]

Hi,

The code should work if the info you provide is what is actually being looked at in the actual data.

As for the account that end with "bc" is it the at the end of the account or at the beginning?

If you could attach another copy of the work book and if possible all the variable that your looking for.
If I do not respond today someone on the forum may, else I look at it when I get back today.

[jlederman]

Charles,
Thanks again for your help. I have attached another sample copy. The bc is at the end of the account name.

I would like to have the following accomplished:
Accounts ending with "tlr" moved to the NO ACTION (i.e. fbktlr3, dnbtlr4, etc)
Accounts with "room" or "conf" moved to the NO DELETE (i.e. psqlunchroom)

[Charles]

Hi,

Sorry for the delay, but this is what I came up with. However you have "aaaa" and other info that this code does not address.

[jlederman]

Charles,
The aaaaa and bbbbb accounts that I placed there were only to test if the existing rows that had data were removed. When I run the macro, I would like to have no blank rows between those accounts that were not affected by the macro. The accounts affected by the macro will be those that we know are going to show up on the report. The accounts that we are unaware of (users being terminated, retiring, disability leave, etc) will stay in the investigate sheet until we find the reason that they have not logged into the network for several weeks.
Everything is great, but it would really be nice to have those rows deleted once they have been moved to the respective sheet.

[Charles]

Hi,

All of the data in the sheet for "Investigate" should move to the correct sheets. After the code runs the "Investigate" sheet should be blank except for except for the unaccounted "unaware of" info.

[Charles]

Hi,

I re-vamped the code to delete the lines instead of clearing.
I hope this is what you wanted.

[jlederman]

that is exactly what i am looking for Charles!! Thanks again for all your effort and time you have invested. I appreciate tremendously!!

[Charles]

Thanks for the feedback.