| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Skip Reference Sequences during copy
Cell A1 countsif a value appears in cells b1; b2 or b3. I want to copy cell
A1 into cell A2 etc but want the countsif reference to jump to b4; b5 or b6. Currently if I copy it down to A2 the reference changes to b2; b3 and b5. I need to copy hundreds of cells like this and I'm trying to avoid doing it manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip columns and copy formulas | Excel Discussion (Misc queries) | |||
| Skip cells and copy formulas | Excel Discussion (Misc queries) | |||
| Skip and copy formulas | Excel Worksheet Functions | |||
| How can i get a IF formula to skip to the next reference box | Excel Worksheet Functions | |||
| How do I copy cells and skip lines? | Excel Discussion (Misc queries) | |||
Threaded Mode
