Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-Spreadsheet text and data extraction
I'm having trouble figuring out how to code a macro that will perform this
function: -Extract text in a column of spreadsheet #1 -Look up that same text in a column of spreadsheet #2 -Either highlight it for later use and/or -Copy data within the same row of spreadsheet #2, but a different column associated with the extracted text from spreadsheet #1 -Return to spreadsheet #1 and paste the data extracted from #2 into the same row, but a new column. This is apart of a data mining exercise in a cancer research lab. It falls under the realm s of bioinformatics, but since so many people here appear to be expert, I figured I ought to start here. Cheers, taiwansmith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-Spreadsheet text and data extraction
I think I would bring the data into Access as separate tables (either import
or linked tables). Then build a query joining the two tables on the column you speak of. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "taiwansmith" wrote: | I'm having trouble figuring out how to code a macro that will perform this | function: | | -Extract text in a column of spreadsheet #1 | -Look up that same text in a column of spreadsheet #2 | -Either highlight it for later use and/or | -Copy data within the same row of spreadsheet #2, but a different column | associated with the extracted text from spreadsheet #1 | -Return to spreadsheet #1 and paste the data extracted from #2 into the same | row, but a new column. | | This is apart of a data mining exercise in a cancer research lab. It falls | under the realm s of bioinformatics, but since so many people here appear to | be expert, I figured I ought to start here. | | Cheers, | taiwansmith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-Spreadsheet text and data extraction
If you are going to keep your data in excel rather than moving it to access,
then This is tailor made for the Vlookup function. (no programming required) Look at the examples in excel help for the lookup functions: vlookup, hlookup, lookup, combination of Index and Match. -- Regards, Tom Ogilvy "taiwansmith" wrote in message ... I'm having trouble figuring out how to code a macro that will perform this function: -Extract text in a column of spreadsheet #1 -Look up that same text in a column of spreadsheet #2 -Either highlight it for later use and/or -Copy data within the same row of spreadsheet #2, but a different column associated with the extracted text from spreadsheet #1 -Return to spreadsheet #1 and paste the data extracted from #2 into the same row, but a new column. This is apart of a data mining exercise in a cancer research lab. It falls under the realm s of bioinformatics, but since so many people here appear to be expert, I figured I ought to start here. Cheers, taiwansmith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Text import and data extraction | Excel Discussion (Misc queries) | |||
Automate extraction of data from mainframe report into spreadsheet | Excel Discussion (Misc queries) | |||
text extraction | Excel Programming | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
Text Extraction | Excel Programming |