Finding and delelting multiple fields at once in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

polihale

Thread Starter
Joined
Feb 8, 2013
Messages
1
Hello, I consistently work with reports containing raw data that is pulled from one of our databases. I use this data to update a master copy of another report that I use to track completion status of a particular training program. The raw report shows completions and date completed and is pulled from our database. I possess more up to date information than the database often does, so when I update my master report with the database report I am doing it manually by person. What I would like (unless there is a better recommendation) is to be able to copy/paste all data from the raw report into mine, then do a quick find/delete of names that I know should not be on the master report, but that the database has not been updated with yet, as opposed to toggling back and forth between reports to ensure I am not listing someone on my master as incomplete (per the database) when I know they have completed it. I hope this makes sense and I really appreciate the forum.
 
Joined
Sep 4, 2003
Messages
4,912
What you want can easily be automated. Can you provide some sample files with dummy data so we can see exactly what you are talking about.

Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top