autofill formula to every section of data
 

i import updated data everyday into a spreadsheet i created that calculates
numbers if certain criteria are met. my question is, my imported data
usually consists of 250-350 different items which each have 1-13 rows.
currently, i sit here and paste the formula manually after each section of
data and i get the infomation i need, is there a way excel can just paste the
formula after each section of data?

autofill formula to every section of data
 

Jason

Select the column with the data sets and F5SpecialBlanksOK

Type your formula into the active blank cell then hit CTRL + ENTER.

Should do what you want.


Gord Dibben MS Excel MVP

On Sat, 23 Dec 2006 08:46:01 -0800, Jason
wrote:

i import updated data everyday into a spreadsheet i created that calculates
numbers if certain criteria are met. my question is, my imported data
usually consists of 250-350 different items which each have 1-13 rows.
currently, i sit here and paste the formula manually after each section of
data and i get the infomation i need, is there a way excel can just paste the
formula after each section of data?

autofill formula to every section of data
 

thanks, but that wasn't what i was looking for, i should have been more
descriptive. along with the data of 250-350 items, 1-13 rows, it also has
columns A-J. and after each section there is usually 6-7 blank rows. i
would usually just paste the formula a row or two below each section.

so my current formulas are :

=IF(B8=24,SUM(I1:I12),0) <-- this is for hours
=IF(B8=24,SUM(J1:J12),0) <-- this is for minutes
=IF(B8=24,COUNT(G1:G12),0) <--this is for number of entries
the "B8= " is the date i change manually daily so the correct information is
pulled

hopefully i have gave you a better idea of what i'm doing, so you are able
to help, if not, i can send you sample of the file

"Gord Dibben" wrote:

Jason

Select the column with the data sets and F5SpecialBlanksOK

Type your formula into the active blank cell then hit CTRL + ENTER.

Should do what you want.


Gord Dibben MS Excel MVP

On Sat, 23 Dec 2006 08:46:01 -0800, Jason
wrote:

i import updated data everyday into a spreadsheet i created that calculates
numbers if certain criteria are met. my question is, my imported data
usually consists of 250-350 different items which each have 1-13 rows.
currently, i sit here and paste the formula manually after each section of
data and i get the infomation i need, is there a way excel can just paste the
formula after each section of data?