Look up and Transfer Data

L

Lost in Sport

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?
 
H

Hulkascooby

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?
 
Top