Thread: Calculate number of rows and apply formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Grey Old Man[_2_] Grey Old Man[_2_] is offline
external usenet poster
  
Posts: 24
Default Calculate number of rows and apply formula
I need to count the rows in a sheet named 'Imported Data' where the column
range is A:R.

The conversion is applied in a sheet named 'Converted Data' where the
formulae are all in row 2.

I need to automatically fill down from 'Converted Data'!A2:R2 until it
reaches the row count of 'Imported Data'


Reply With QuoteReply With Quote