Hi everyone , i have a daily tracking sheet , with columns for each day of the week , no problem here , i then have a row of data where 5 cells are merged for each 5 days worth of dates ,here a value is entered weekly ( this is used to show the value for the week not the day ), i need to report this value for every friday , unfortunately if i reference this column and row i get a blank , as the merged cells ( 5 cells ) only 1 cell really contains the data , is there a way of extending the value across all 5merged cells automatically ?? example attached
Once i have done this i then need to look through all the worksheets to retrieve all fridays , the date associated and the values for fridays ... again any help greatly appreciated ...
Bookmarks