| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and paste - help with code
Hello all, I have been trying to modify some code to do the following,
A B C D E E 0014166 0141 6771230 11 01 14-Feb-07 6771230 3614 6765118 2152 2753438 11 01 09-Apr-07 Sheet "Tool Tracking" A B C D E F 6771230 97 ZEAFHZP VA37 Z013261 20070620 6774767 VG96 2734467 20070317 Sheet"LCS" I need to compare the numbers in "A" on both sheets, if found on both sheets, check "Tool Tracking" for value in "C", if nothing then check "E" on "LCS" if there is a value then copy cell in "E" from sheet"LCS" to "Tool Tracking" - The value "Z013261" in the example above must be copied to "C" in sheet "Tool Tracking". Some code would be greatly appreciated. Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a Unique code cut and paste | Excel Discussion (Misc queries) | |||
| Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| code to FIND value, copy, paste values onto other sheet | Excel Programming | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
