|
|
#1
08-14-2012, 09:17 AM
|
|||
|
|||
would really appreciate any assistance. i have inherited a spreadsheet in which figures in one column(colD) should sum to zero based on references in 3 "random" rows in the spreadsheet. i am attempting to automate this task.
Part of the ref1 in colA is added to row 2 as ref3. So i could link these 2 rows by extracting the number from the first row. There is a second number linking the second and third row - colB row 2 and colA row 3. i am thinking of finding the ref that links rows 2 and 3 and copy and paste the ref from the first row but having some difficulty. Any assistance would be greatly appreciated thanks in advance for you help jer see file enclosed Last edited by macropod; 08-14-2012 at 07:50 PM. Reason: Merged posts as the attachment is much more meaningful than the (deleted) description. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 "Paste cells" in paste menu
|
averagejoe | Word | 2 | 03-13-2012 05:40 PM |
|
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
| Cut and Paste | Ray1955 | Excel | 1 | 09-21-2011 05:38 AM |
|
Is there a way to use "find/replace" to find italics words?
|
slayda | Word | 3 | 09-14-2011 02:16 PM |
|
can Find/Replace NOT find something?
|
Bobosmite | Word | 6 | 05-27-2010 08:09 PM |
Windows 7 32bit 
Office 2007
Threaded Mode