Oct 17th, 2012, 08:00 PM
Looking up data from one Excel Sheet and putting on another
First of all I would like to apologies firstly if this is in the wrong section however I'm needing some help if possible please.
I have a worksheet and on that has the following cell headings - In The Box Leader Staff System CI QA ATS
What I'm trying to do is write a macro or code to pick up all the people with 1 under the in the box fields and then gather the rest of the data and place it into another worksheet for me.
I hope someone can help me.