weekly changing functions

[brachylagus]

I quote insurance. My work uses a calendar style layout to track the number of quotes done a day by each person on the team. A query is run in our quoting program, and those numbers are manually entered into the spreadsheet. My boss wants me to create a new page where the weekly totals, and contribution scores of each team member are shown in a chart and on a graph. He wants this to automatically change what week it's tracking based on what week we're in, without having to manually change the function. Is this possible? If so, how?

Thanks in advance.

[Bryan Hessey]

I quote insurance. My work uses a calendar style layout to track the number of quotes done a day by each person on the team. A query is run in our quoting program, and those numbers are manually entered into the spreadsheet. My boss wants me to create a new page where the weekly totals, and contribution scores of each team member are shown in a chart and on a graph. He wants this to automatically change what week it's tracking based on what week we're in, without having to manually change the function. Is this possible? If so, how?

Thanks in advance.

Hi,

a nice project you have scored there.

You will, of course, need a little VBA code to help, if you 'Record New Macro' whilst setting up one sheet you can then adjust this and use it as the base of the macro required.

For the Week number, something like =WeenNum(Now(),1) should give you the current week number, but you will need the Analysis Toolpak installed to use that (Tools, Add-Ins, add Analysis Toolkit).

hth
---