autofill formula to every section of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Jason

Select the column with the data sets and F5>Special>Blanks>OK

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

Should do what you want.


Gord Dibben MS Excel MVP
 
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
 
Back
Top