Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
Hi
best you post your current code / your current functions and explain exactly what you're trying to achieve -- Regards Frank Kabel Frankfurt, Germany Any ideas how I do this? Each month has exactly the same layout, all that changes are the types of data within each one. I can perform the functions manually, but if I could get a peice of code to make Excel automatically do this it'd make my life easier :) Thanks WB5 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
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 -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
I'm using the COUNTIF function to work out how many, but the range need
determining somehow. WB -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
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) "WorkerB5 " wrote in message ... I'm using the COUNTIF function to work out how many, but the range needs determining somehow. WB5 --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Targeting different worksheets dependant on the date
Thanks. I'll give it a go in work tomorrow and get back to you.
WB -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I require code to run a macro dependant on the date | Excel Discussion (Misc queries) | |||
Using parameters to use different source files dependant on the date. | Excel Discussion (Misc queries) | |||
Date dependant values. | Excel Discussion (Misc queries) | |||
Opening a Worksheet Dependant on Date | Excel Programming | |||
Formula dependant on month/date | Excel Programming |