Hi,
I have this worksheet Snap shotwhich is linked to another sheet.
every day I need to replace the raw file with new data and hence the row number and column number changes as well.
For example --
last week the formula was
=COUNTIF(dummy1!$Q$6:$Q$44,1)
This week it may change to
=COUNTIF(dummy1!$Q$16:$Q$48,1)
Now I need to change it for all cells,please advice a fast find and replace,so that I can do all replaces at once.