Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look up and Transfer Data
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? |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transfer data from Notepad to Excel? | Excel Discussion (Misc queries) | |||
Can I transfer data from and excell spreadsheet to print labels u. | Excel Discussion (Misc queries) | |||
Data Base Link | Excel Discussion (Misc queries) | |||
lookup and transfer data | Excel Discussion (Misc queries) | |||
can I transfer data from sheet 1 to sheet2? | Excel Discussion (Misc queries) |