View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mark Brown[_2_] Mark Brown[_2_] is offline
external usenet poster
 
Posts: 2
Default Copying formulas

Carol,

If you put a "$" directly before the column reference in the formula (for
example, $F32), the column reference will not change. Likewise, a $ before
the row reference makes it not alter.

I'm not sure about your other question, sorry.

Mark

"englishrose4719" wrote:

How do I copy a formula along 31 columns in a summary spreadsheet without it
altering the column references? Because the data is coming from identical
spreadsheets but on different days of the month i need only the sheet number
to change.

Also is there a quick way to copy and paste the first formulated spreadsheet
across to the 30 others in one hit? Ive tried a couple of ways already
suggested but didnt get very far.

Thanks lots
Carol