I am new to this forum and a fairly well versed user of Excel, and looking forward to not only helping others but getting help when I'm stumped, so here it goes. I have a jobs report with the jobs numbered vertically. Each job has status info that is approximately 20 columns wide. The jobs are tracked in one of four stages indicated by an "X" in a particular column pertaining to that stage. I would like to extract all the data in each row and create a separate sheet with just those jobs within each of the four stages, keeping the original report intact. Is there custom programming or a macro for this. Thanks.
Bookmarks