Look up and Transfer Data

[Guest]

I have multiple spreadsheets that I want to move certain information from to
get all my info into one spreadsheet. Is there anyway to search mutiple
spreadsheets by a column like "Area" and tell it to retrive another
multiple colums like "Sport", "venue", "day", "date" etc then post it into a
corresponding column in another
worksheet by matching "Area"??
also information input into seperate spread sheets should also update the
spreadsheet with merged ino?

 

[Dave O]

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.

 

[Guest]

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

 

[Dave O]

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.

 

[Guest]

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?