Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy & Paste "Equal" Function: Adding Distance
I'm hoping someone can help me with the following:
1). In (sheet 2, cell A1) I use the Equal formula to make it "= sheet 1, cell A1" 2). Still in Sheet 2: I copy & paste (cell A1) into (cell A2). Of course, my result will be "= sheet 1, cell A2) as the formula will maintain my original distance. *However, I need the result to be "= sheet 1, cell A6." How can I do this - get it to "skip" cells so to speak? Any Help will be most appreciated and save me a considerable amount of time in hard keying formulas in. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty a cell if the values equal to "IN" , "MC" or "PP" | Excel Programming | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Returning a distance from a tabel, given "from" and "To"? | Excel Worksheet Functions | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |