Jasen
04-17-2016, 03:46 AM
Hi, I hope I can explain this and make sense - I'd love a pointer here.
I'm trying to add a range of figures from other sheets where the sheet name and ranges can vary.
The sheet name is going to be selected from a data validation list which is in cell C6. The desired sum date range (from and to) will be also via validation of a choice of 1 to 31 which will be in cells D6 and E6 respectively.
The 1st date in whichever source sheet is chosen from the validation list, will be in column F and the 31st date is in column AJ.
I'd like to be able to choose the from date, to date, source sheet and get a sum of those dates. For example if 7th to 13th is chosen then it would return to the destination cell the sum of Columns L to R of a specified row.
I'd like to do this for several rows.
I'm unsure how to approach this.
If possible to do via formulae rather than macros that would be great.
Any advice much appreciated, thanks!
I'm trying to add a range of figures from other sheets where the sheet name and ranges can vary.
The sheet name is going to be selected from a data validation list which is in cell C6. The desired sum date range (from and to) will be also via validation of a choice of 1 to 31 which will be in cells D6 and E6 respectively.
The 1st date in whichever source sheet is chosen from the validation list, will be in column F and the 31st date is in column AJ.
I'd like to be able to choose the from date, to date, source sheet and get a sum of those dates. For example if 7th to 13th is chosen then it would return to the destination cell the sum of Columns L to R of a specified row.
I'd like to do this for several rows.
I'm unsure how to approach this.
If possible to do via formulae rather than macros that would be great.
Any advice much appreciated, thanks!