Replies

thank you for your quick respone and i hope you had a good new year

what i should have said is that i would like to select “B3:B221″and paste B2 into it. The end row can variable, how can i do this without having to know what the end row is

Subject edited by HansV

i would like to copy a formula in cell “B2” down as far as the last cell in colum “A”
cell “B2” is “=if (B2=1,”Y”,””)
can any one help with a better solution than copy and paste on the fly

Subject edited by HansV

i would like to copy a formula in cell “B2” down as far as the last cell in colum “A”
cell “B2” is “=if (B2=1,”Y”,””)
can any one help with a better solution than copy and paste on the fly

it works a treat very quick as well thank yo to Legare Coleman for his solution and to all who replied
thank you one and all

it works a treat very quick as well thank yo to Legare Coleman for his solution and to all who replied
thank you one and all

sorry for not replying sooner but i have been out of town all weekend, just a quickiereply.

yes the number of rows can vary from 2 to 22 wich i agree is very dishartening if you have 500 plus calculations to make.

i will get back to you tommorow with a result

sorry for not replying sooner but i have been out of town all weekend, just a quickiereply.

yes the number of rows can vary from 2 to 22 wich i agree is very dishartening if you have 500 plus calculations to make.

i will get back to you tommorow with a result

works a treat
thank you

works a treat
thank you

yoyophils function
=IF(ISERROR(E4)=TRUE,SUMIF(‘#VALUE’!A:A,Sheet1!A4,’#VALUE’!E:E),E4) the function works like a dream, if you remove the TRUE from the function you only get TRUE or FALSE not the actual value
to legare coleman, i would like to say thank you for your suggestion, on CSV values i hope to tryit out shortly and see what difference it makes to the working i have used to get round the problem in the past.
than you to yoyophil and to legare for all the help they have give in resolving my queery

yoyophils function
=IF(ISERROR(E4)=TRUE,SUMIF(‘#VALUE’!A:A,Sheet1!A4,’#VALUE’!E:E),E4) the function works like a dream, if you remove the TRUE from the function you only get TRUE or FALSE not the actual value
to legare coleman, i would like to say thank you for your suggestion, on CSV values i hope to tryit out shortly and see what difference it makes to the working i have used to get round the problem in the past.
than you to yoyophil and to legare for all the help they have give in resolving my queery

it looks good i will try it out on tuesday with Legare Coleman suggestions

thanking one and all for your input

it looks good i will try it out on tuesday with Legare Coleman suggestions

thanking one and all for your input

i thought by using “#VALUE” i would remember what i had done and why i needed the 2nd sheet also for othere people to follow what i have done, your comments are welcome and i will change the sheet name to something more appropiate (don’t laugh) “ErrorValues”
on your second point. this is a down load from a proteus system and is a pain as i have to download as a CSV , change any numerical/text type numbers by
multiplying the noumber x 1— any suggestions for a better result would be appreciated

i thought by using “#VALUE” i would remember what i had done and why i needed the 2nd sheet also for othere people to follow what i have done, your comments are welcome and i will change the sheet name to something more appropiate (don’t laugh) “ErrorValues”
on your second point. this is a down load from a proteus system and is a pain as i have to download as a CSV , change any numerical/text type numbers by
multiplying the noumber x 1— any suggestions for a better result would be appreciated