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