Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background copy macro
Hi,
Is it possible to have a copy paste macro that runs in the background, as in the user does not need to push a button or do anything? I guess to avoid the macro constantly updating when the user is in the file it would be best if the macro ran when closing the file. I have a table with names, dates etc in it going from col B to U. In col J I have the a ranking values which is either 2,4,6,8 or 10. In U I have an X if its an interesting item or not ( it filters whether certain actions have been completed etc). I would like a macro that takes all of the items with a 10 in col J AND an X in col U and put them into an adjacent sheet named Urgences. Items with either a 4 AND an X or a 6 AND an X go into a sheet named Imperatifs. Is this sort of automatic filter/copy/paste on closing macro possible? Thanks LiAD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please share how to place DRAFT Copy in Excel in background | Excel Discussion (Misc queries) | |||
Please share how to place DRAFT Copy in Excel in background | Excel Discussion (Misc queries) | |||
How to make a cell copy the info from another (background colour i | New Users to Excel | |||
How do I copy background (wallpaper) from one worksheet to another | Excel Discussion (Misc queries) | |||
Background Copy Distorted | Excel Programming |