Becxky explained on 5/2/2012 :
I currently have a spreadsheet containing data about students in our
organization. At the bottom of each column, I have inserted formulas to
total the various data / text / data range occurrences. Each formula is
set to read a dynamic column (for example, to calculate the number of
students we have from latin america, among other regions, I use:
=COUNTIF(I$2:INDIRECT("R[-1]C",0),"la"). This works perfectly when I am
inserting new rows and entering information cell by cell.

My problem is that I wish to copy / paste data from other spreadsheet
documents into the main spreadsheet. I insert the appropriate number of
rows and copy/ paste the new data. When I do, the formulas won't
register the new values - only the data that was there previously.

Is there any way that I can copy / paste data so that my formula's read
it?

I would GREATLY appreciate your help!!

Thanks

To add to Spencer's advice, I normally use 'Paste Values' when
importing data from other sheets so my target sheet's formatting
doesn't get screwed up.

What makes your column 'dynamic'? If it truly is dynamic then there
should never be any reason why its content doesn't calculate (except
blank cells, of course).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion