Thread: COPY DOWN INCREASING WORKSHEET REFERENCE BY 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
  
Posts: 159
Default COPY DOWN INCREASING WORKSHEET REFERENCE BY 1
I've got =SUM(BDM001!M;M) in C6, ie referring to column M in worksheet
BDM001. In C7, I want =SUM(BDM002!M:M0, ie referring to worksheet
BDM002, in C8 I want =SUM(BDM003!M:M), etc. How do I copy down?
Reply With QuoteReply With Quote