Buyone
07-25-2007, 02:10 PM
Hello people! I'm back with another quandry to test the skills of the excel knowledgeable out there! (my last problem was solved "whilst blindfolded and juggling flaming chainsaws" it was that easy by Charlize and Xld)
I've got a costs sheet which I update twice weekly. The costs come in two different excel spreadsheets and I save down what I need to a long list.
Now I tried to just save them down as the same file name and have links to the file I used. But for some reason the clever people sending me the info move it around (only by a column or row) but still enough to make my link useless!
Does anyone have an idea where I could start? I thought of the go find macro but the sheets also include last yrs costs above with the same titles etc!
Many thanks
I've got a costs sheet which I update twice weekly. The costs come in two different excel spreadsheets and I save down what I need to a long list.
Now I tried to just save them down as the same file name and have links to the file I used. But for some reason the clever people sending me the info move it around (only by a column or row) but still enough to make my link useless!
Does anyone have an idea where I could start? I thought of the go find macro but the sheets also include last yrs costs above with the same titles etc!
Many thanks