| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy cell formula help
I've created a spreadsheet with a dozen colums and about 150 rows.
in the 1st row cells I have a conditional formula which states Sumif "cell Range", "Salesman Name", "Copycell Range". I'm trying to copy and paste the whole column in the hopes I retain the same cell ranges and formula, but evertime I paste from column A to Column B the whole range shifts the column range. My question is this; Is there a way to keep the conditions in the formula from changing? Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a formula as text to another cell? | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Threaded Mode
