View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AllyD AllyD is offline
external usenet poster
 
Posts: 2
Default Capturing Rows of Data

Help please.

I have two worksheets of text data - the first column of which have common
designators heading each row. I would like a summary sheet that can capture
all the data on the row that has a designtor that I choose. Example:

Jan Feb Mar
A1 Begin Move Issue Instruction Deploy Tool

A2 No action rqd Issue Letters Hold Party


I would like it such that when I call up 'A2' - I get the data 'No Action
Required', 'Issue Letters' and 'Hold PArty'


Is this possible?

Ally