Jason, There can be a way to automate end-to-end, of what the employees are doing or may be to some extent atleast
Can you send a sample sheet to the group People will be able to help you a bit faster by looking at it Cheers Harry On Jun 8, 4:59 pm, JsinSk <jsin...@gmail.com> wrote: > Hello All, > > At my workplace we have a report that is run every 15 minutes, it > takes an employee nearly all of those 15 minutes to process and report > the data to the group. I'm looking for a way to help automate this > somewhat for the employee so he can work on other tasks through the > day as well. > > Background: > The report is generated in another application, he copy/pastes the > information into excel then formats how he wants it. He highlights all > the data in yellow. He then runs the report again and does the > formatting then sorts by column A. He then goes through and deletes > all the duplicates in the white (non colored) cells, but leaves the > yellow ones. The new report is sent out with yellow (duplicate) and > the new data in white. > > Question: Is there a way to automatically delete a row if the > following conditions are met? > > • It's a duplicate > • The cell color is white only > > The fresh data that was not a duplicate needs to remain on the sheet > in order to be sent out. > > If you need more data please advise. > > Regards, > > Jason -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
