Search results for query: *

Hi - I'm having a problem trying to group date values in a Pivot Table in Excel 97. I have one worksheet with a list of transactions from the last two years which have start dates and end dates, and I'm trying to produce 2 separate pivot tables, one which counts the number of transactions...

And I'd just like to say thanks very much to Hasit! ;-)

Hasit - No macros, but I've checked the VBA editor anyway. I'll email you the sheet separately. Thanks for the help! ;-)

Hasit, I've checked Edit / Links already (mentioned in my first posting), and, yeah, the reference to the other worksheet is still there. But there shouldn't be any reference. I've manually looked at every cell where the reference was before I pasted the values, and have also done a Find on...

I don't want to interrupt your chat, but: The problem is that I don't want the link to the other sheet to be there, 'cos the people using the second spreadsheet won't have access to the first spreadsheet. I've pasted into the second sheet as "values" specifically for this reason...

Hi - I've created a spreadsheet which uses lookup formulas to change values in a worksheet depending on a value selected by a user from a list (I'm using Data Validation to restrict data entry). The resultant cell values also need to be included in other spreadsheets, but for these spreadsheet...

I've inherited the above as a salvage piece from a friend, but have been unable to get it either to burn a cd or to play a feature DVD all the way through. It can read data DVDs perfectly well, and the testing process and speed checks work ok in both Nero and Easy CD. Every time it starts to...