| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell References
I have 2 separate work sheets. I want to copy the values of cells in work
sheet A to cells in Work sheet B. The values in A are separated by at least 4 rows. Cells in B where I want those values are separated by 1 row. How can I copy the values without having to enter each cell reference indivudually in B? Is there a formula to add columns or rows such as cell A1+3 = cell D1 or cell A1 + 3 = cell A4 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel insits that I use absolute cell references | Excel Discussion (Misc queries) | |||
| Fixed cell references | Excel Discussion (Misc queries) | |||
| How to use complex no. functions that have cell references? | Excel Worksheet Functions | |||
| Cell references change when entering new data | New Users to Excel | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Threaded Mode
