Please advise. I still cannot see an option to attach a file. If no reply I will upload to another site and link..
On Jun 8, 9:16 pm, Harpreet Singh Gujral <harpreetguj...@gmail.com> wrote: > 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
