Changing the range within several functions

Dear forum

I was hoping to get some help. I have created a spreadsheet for clients where employees will add anonymous data from their files and the spreadsheet then extracts and analyses across the group time of arrival, age etc using various functions. The problem is that currently, when I want to change the range of files to analyse and display (for example instead of January which is rows 3-10, I want to select March which is 18-30), I am using the 'Find and Replace all' manually to change the range of cells within each of the functions. I was hoping to do is to put two separate cells with 'Start of range:' and 'End of range:' - each of the functions would then use the content of these cells as the range. Is this possible / easy to do? I imagine the answer is yes!

Hi there,

Can you post a sample of your workbook here so that we can get an idea of its layout?

Regards,

Greg M