J
J-McC
I want to be able to check a spreadsheet that has the week number (1
to 52) that a client calls and how many times in the last week he
called to a simple result showing week number and how many times he
called.
The more I read about excel the more I realise what can be done with
it.
I have attached a sample of the spreadsheet form I have and I was
thinking of having a macro that starts in the last week column, checks
the cell on its left and if it is a blank then to repeat the cell on
the left until it finds a number. It is now to copy this number into
the right hand cell called "no of calls" and in the weekno cell it is
to place the weeknumber (column) eg weekno =14, calls=5
Then it is goto the rh cell, drop down a row and repeat this procedure
again. When it reaches the last row (approx 24000 rows) it is to then
stop.
Jim McC. (e-mail address removed)
to 52) that a client calls and how many times in the last week he
called to a simple result showing week number and how many times he
called.
The more I read about excel the more I realise what can be done with
it.
I have attached a sample of the spreadsheet form I have and I was
thinking of having a macro that starts in the last week column, checks
the cell on its left and if it is a blank then to repeat the cell on
the left until it finds a number. It is now to copy this number into
the right hand cell called "no of calls" and in the weekno cell it is
to place the weeknumber (column) eg weekno =14, calls=5
Then it is goto the rh cell, drop down a row and repeat this procedure
again. When it reaches the last row (approx 24000 rows) it is to then
stop.
Jim McC. (e-mail address removed)