Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross worksheet find and paste
I have a workbook with multiple worksheets in it. I have to consolidate an updated value into the primary worksheet from new versions of the other worksheets daily. The primary sheet is formated as such ID Name OldValue NewValue idnum Jhon 402 340 the other worksheets have a corresponding ID column and a value colum, I just need to loop through all the ID's in the id column in sheet A, find that idnum in worksheet B, select the value from worksheet B, and paste it into NewValue on worksheet A. I imagine its pretty straightforward, I apoligize in advance for my ignorance. Thanks for your help - Kevin J -- TheIconoclast ------------------------------------------------------------------------ TheIconoclast's Profile: http://www.excelforum.com/member.php...o&userid=30809 View this thread: http://www.excelforum.com/showthread...hreadid=504706 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find values by cross columns and rows | Excel Discussion (Misc queries) | |||
What is cross totalling and where do i find it? | Excel Discussion (Misc queries) | |||
Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
cannot find cross and tick box just below the toolbars | Setting up and Configuration of Excel | |||
How do I find a cross reference value | Excel Discussion (Misc queries) |