Targeting different worksheets dependant on the date

  • Thread starter Thread starter WorkerB5
  • Start date Start date
W

WorkerB5

Any ideas how I do this?

Each month has exactly the same layout, all that changes are the type
of data within each one. I can perform the functions manually, but if
could get a peice of code to make Excel automatically do this it'd mak
my life easier :)

Thanks

WB
 
Hi
best you post your current code / your current functions and explain
exactly what you're trying to achieve
 
The spreadsheet is at work atm, but I can remember enough.

The layout is

: DATE : NAME : REF : DATA : TYPE :

There is one row at the top with those as headers, then data of eac
type down the spreadsheet.

I have 12 worksheets for each months dispatch, and 1 worksheet whic
calculates the number of each type of transit each month, the tota
transits and then works them into percentages.

I've been asked to provide a breakdown for each week as well... this i
the problem part.

I need some code which will sit on a 5 week display and calculate ho
many of each transit went in each week. I can modify the formulae I'
using to calculate monthly to do it weekly, but I need something t
provide the data range, which in many cases will be on differen
worksheets and for some weeks will be on two worksheets...

Is it possible, or should I rework my worksheet?

Either way, I need to be able to display a running total for each wee
section.

WB
 
I'm using the COUNTIF function to work out how many, but the range need
determining somehow.

WB
 
You can get the range with

OFFSET(A1,,,COUNTA(A:A))

something like

=COUNTIF(OFFSET(A1,,,COUNTA(A:A)),weeknum)

but why not just use the whole of the coilumn

=COUNTIF(A:A,weeknum)

(BTW not really sure how you will test, so my examples may need to be
adapted to your real situation).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using xlsm worksheets on different computers 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Code to delete names works in one WB, but not another WB? 2
Can UDF modify worksheet(s)? 5
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Save Date in File Name 3
Counting multiple memberships 1
Access Access Recalculating Targets 0

Back
Top