View Single Post
  #1   Report Post  
Allen Way via OfficeKB.com
 
Posts: n/a
Default combining data from multiple sheets

I have two worksheets each with different employee data: names, job title,
shift, days off, etc. All the employees in the 2nd sheet are also in the
1st; only some of those in the 1st are in the 2nd. The 2nd is kind of a
subset of the first, however, the only column the two have in common is
Name. I want to combine the two sheets so the info from the 2nd is placed
into new columns in the correct rows of the first. How?

--Allen

--
Message posted via http://www.officekb.com