| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CROSS REFERENCE BETWEEN WORKBOOKs
In WB1, I want to insert a formula, via VBA, that compares Col sequentially down with Col A of WB2; each of these columns contains string of 16 - 20 characters in each row; if there is NOT a "strin match", the formula result is an "X". I would appreciate any help. Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=32020 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CROSS REFERENCE BETWEEN WORKBOOKs
Workbooks contain sheets. Sheets contain columns.
-- Regards, Tom Ogilvy "Chuckles123" wrote in message ... In WB1, I want to insert a formula, via VBA, that compares Col A sequentially down with Col A of WB2; each of these columns contains a string of 16 - 20 characters in each row; if there is NOT a "string match", the formula result is an "X". I would appreciate any help. Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=320208 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CROSS REFERENCE BETWEEN WORKBOOKs
Would I be better off copying WB2, Sheet1 (it is smaller of the tw WB's) into a newly created and named WB1, Sheet2? Does this make th cross-reference easier? If answers are 'yes', please advise. Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=32020 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CROSS REFERENCE BETWEEN WORKBOOKs
I don't think it will make much difference. The references would be
shorter. See Chip Pearson's site for some ideas: http://www.cpearson.com/excel/duplicat.htm -- Regards, Tom Ogilvy "Chuckles123" wrote in message ... Would I be better off copying WB2, Sheet1 (it is smaller of the two WB's) into a newly created and named WB1, Sheet2? Does this make the cross-reference easier? If answers are 'yes', please advise. Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=320208 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross referencing two workbooks? | Excel Worksheet Functions | |||
| cross referencing 2 workbooks at same time | Excel Worksheet Functions | |||
| Cross reference | Excel Discussion (Misc queries) | |||
| Cross Reference 2 columns in seperate workbooks | Excel Worksheet Functions | |||
| Cross referencing data across different workbooks | Excel Discussion (Misc queries) | |||
![Chuckles123[_74_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
