| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to use next cell in line
Hello, I need to copy a row and paste it several rows down. I have a formula
='Sheet1'!A5 in row 6, and if I try and paste it 10 rows down in row 16, it changes to ='Sheet1'!A15 The problem is, I need it to say ='Sheet1'!A6 so is there a formula I can use that adds only one cell down, instead of the row number its being pasted on? I have a list of titles on Sheet1 that I need to be put in rows on Sheet2 and have lines to sign up underneath, but I don't want to have to change each one to the next cell on sheet1. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - every cell starts with ' r ^ in the formula line! | Excel Discussion (Misc queries) | |||
| Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
| How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
| How do I enter a formula that will delete a line when a cell = 0? | Excel Worksheet Functions | |||
| A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Threaded Mode
