Formula's won't read copy / pasted data ?

[Becxky]

I currently have a spreadsheet containing data about students in ou
organization. At the bottom of each column, I have inserted formulas t
total the various data / text / data range occurrences. Each formula i
set to read a dynamic column (for example, to calculate the number o
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 a
inserting new rows and entering information cell by cell.

My problem is that I wish to copy / paste data from other spreadshee
documents into the main spreadsheet. I insert the appropriate number o
rows and copy/ paste the new data. When I do, the formulas won'
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 rea
it?

I would GREATLY appreciate your help!!

Thank

 

[Spencer101]

I currently have a spreadsheet containing data about students in ou
organization. At the bottom of each column, I have inserted formulas t
total the various data / text / data range occurrences. Each formula i
set to read a dynamic column (for example, to calculate the number o
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 a
inserting new rows and entering information cell by cell.

My problem is that I wish to copy / paste data from other spreadshee
documents into the main spreadsheet. I insert the appropriate number o
rows and copy/ paste the new data. When I do, the formulas won'
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 rea
it?

I would GREATLY appreciate your help!!

Thanks

Have you checked that the data you paste in is in exactly the sam
format as that which was there already?

Sometimes they look the same but actually are formatted differently.

You could use the format pasting tool (the icon that looks like a pain
brush) to ensure this is the case.

Other than that, without an example workbook I'd be hard pushed to com
up with a better reason as to why it's not doing what you expect i
should.

S

 

[GS]

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