If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Counting cells between 2 values
Hi
If you like send me a sample of one of your workbooks with a detailed description what you want to achieve and maybe there is an easier solution. I'm still not sure, what kind of #weekly' report you want to create. Why do you want to access all worksheets within one workbook if each workbook represents only 1 day of your month Frank for some reason that add-in isn't working right, maybe i'm doing something wrong, I"ll give it a second looking over in a minute. In the meantime, is there anytype of VBA alternative to this? I mean, all it is that I'm trying to do is create weekly report. The workbook, is named after the month(Febuary) and each worksheet with the exception of the first and the last (named Top and Bottom) are days of the month (named 01, 02,... ...30, 31). Each worksheet has dates on them, always in the same column. I just want to know how many of the dates are between 2/2/04 and 2/5/04 on all of workbsheets between Top and Bottom. Surely there must be a way to do this. Or some type of alternative approach to getting my results. any help? It doesn't seem that complex, and yet it is... |
Thread Tools | |
Display Modes | |
|
|