| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy formulas by dragging vertically
I have Sheet 1 with raw data in it. Sheet 2, Cell A1 is looking to Sheet1,
H1 for the data (ex. =Sheet1!H1). What formula can I use in cell Sheet2, B1 that will tell it to look to cell Sheet2, A1 and copy the cell just below Sheet1, H1 or (=Sheet1!H2)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formulas from one wkb to another w/out linkng them? | Excel Worksheet Functions | |||
| copy formulas to different cells in another worksheet | Excel Discussion (Misc queries) | |||
| Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
| how to copy formulas to other cells in excell | Setting up and Configuration of Excel | |||
| Copy and dragging cells | Excel Worksheet Functions | |||
Threaded Mode
