Alternate way for "Find and replace"? PlsHelp

Closed
pshycozak - Dec 28, 2010 at 07:12 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 04:41 PM
Hello,

I have an excel workbook which i have to change it everyday. It has two sheets: one of them the operators inputs the daily values and in the second sheet which I operate there are statistical formulas like standard deviation min value max value mean and average. Every morning I open the first sheet and read the row numbers for the day before values entered I note them go to the statistics sheet and "edit -> replace" ( or ctrl+h) and change the row numbers of the statistical formulas row numbers according to the noted row numbers and get the new daily numbers.

To illustrate
=STDEV('FRDG 2010'!H7270:H7377)
25/12/2010 values start in the sheet FRDG 2010 at row 7270 and ends at 7377
26/12/2010 values start in the sheet FRDG 2010 at row 7374 and ends at 7482

I do this by ctrl+h ==> find what 7270 replace with 7374 ok
find what 7377 replace with 7482 ok
I got the new standard deviations etc.




Can I do this automatically?

I tried such a way but could not manage it; I used vlookup function to read the row numbers with today function to read the date and look it up in the first page. Upto this point I got the values ( row numbers that the values of the day before's values started and ended) but couldnt find a way to put them in formulas.



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 9, 2011 at 04:41 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0