Hello,
I'm very new to using Excel so if any of this is obvious please excuse me! So each week I get sent a spreadsheet to fill out,basically it's a breakdown of all the hours my department spent on each task by person each week and some other bits,I get all this information off another sheet in another format and I worked out some simple stuff to link the 2 no problem,however,these sheets get changed every week so each week I would have to highlight all the formulas etc I have put in and then change the workbook link and it changes all the formulas,is there any way to make it change it automatically?
I'm very new to using Excel so if any of this is obvious please excuse me! So each week I get sent a spreadsheet to fill out,basically it's a breakdown of all the hours my department spent on each task by person each week and some other bits,I get all this information off another sheet in another format and I worked out some simple stuff to link the 2 no problem,however,these sheets get changed every week so each week I would have to highlight all the formulas etc I have put in and then change the workbook link and it changes all the formulas,is there any way to make it change it automatically?