Look up and Transfer Data

Ok
How do I get a sample of the worksheet to you?


"Dave O" wrote:

> Your answer is almost certainly "Yes" but in order to help we'd need an
> example of your data. Functions such as VLOOKUP can easily summarize
> data, but the formula you'd use depends on the nature and layout of the
> data.
>
>

Please describe the layout of your data: what data appears on what
tabs, what column headers, etc.
That way the entire newsgroup can suggest ideas.

Pob's Area Ward S&R Area Officer/Contact
Person Venue Sport Category Coach(es) Start Date Finish Date Day Start
Time Finish Time Age-group Avg Att (Cur Per) Known Development
Activity Observations Work To Cease (Reason) Work To Continue (Reason) Action
(Obs) Recommendations Action (Rec) Lead Timescales
These are the colum headings there is a significant amount of data to sort .
I am trying to sort it by area for one sheet and by sport for another is this
any clearer?

"Dave O" wrote:

> Please describe the layout of your data: what data appears on what
> tabs, what column headers, etc.
> That way the entire newsgroup can suggest ideas.
>
>