Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
In sheet A in col AU are more than 600 numers, say 344, 2368 etc. In col BI of sheet A are corresponding amounts (numbers or nothing, no text, no formulas). Sheet B in col. M also has some numbers in it (numbers or nothing, no text, no formulas) which all occur in col AU of sheet A. I need efficient (fast) code to copy the corresponding amount in col BI of sheet A to col N in sheet B, say from row 2 (in sheet B) to row 60. The result (the amount in col N of sheet B) should be like this: sheet A sheet B col AU col BI col M col N row 345 2368 240 row 44 2368 240 I use XP SP2 and Excel 2K. Thanks in advance for your assistance. Jack Sons The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |