Recent content by ajakeway

I'm trying to do exactly the same thing, but in CR 8 it thinks that the formula result should be treated as text so the graph is sorted alphabetically rather than by month. So the order looks like: April-04 August-04 December-04 February-04 etc Is there a way around this? The only thing I...

Interestingly, this also works. =1-ISBLANK(B1) Perhaps not as readable, but I find I can use the Boolean True / False (treated as 1/0) in all sorts of places.

rcrecelius, A simple fix to this without a pivot table, if you prefer. I put that chart in cells B1:E4 (including the titles). In A2, put the formula: =+B2&"P"&D2 The "P" is just a way to separate the location from the part - so P for Part#. Then you can do a Vlookup on that column. With...

How is the data on each page stored? Is it consistently in the same location? Either in a specific cell, or the last cell in a row / column? Can you give us a bit more to work with here?

Why not go through each sheet and add it up? Sub testst() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets 'your calculations here Debug.Print ws.Name ' for example Next ws End Sub

I was looking for some things related to this and noted the following link: http://j-walk.com/ss/excel/tips/tip82.htm which might be of some help. Alternatively... http://j-walk.com/ss/excel/tips/tip18.htm will get a list of file names in a directory. You should be able to easily modify...