Search results for query: *

It would be my advice to save all your files in 2007 Excel as "macro enabled" so that they can all be seen on FILE OPEN, whatever they do. Again the VBA programmers would be good at advising how to make a macro uneditable or hidden to users. Maybe the point is to make the workbook eventually...

[hammer]Those pesky programmers are always playing those sort of tricks on us excel users by ouputting obvious numerical fields as text of with spaces to pad them out to make them look pretty in reports.

I'm not sure how to do it but I seem to remember that in the old days of LOTUS 123 I could have an automatic macro that ran if anyone opened a spreadsheet. If that macro compared todays date with an expiry date it could change the password for subsequent openings. i.e. tomorrow it would have...

Hi Skip, I agree it is a bit contorted but it has come together through applying my existing knowledge. Which is why I was searching for another possible solution. I am an accountant, not a programmer or systems analyst. One of the wonders of computing is that there are multiple solutions to...

What I am currently doing is creating another field in the data, like =Surname&PositionNo This is useful in that it creates unique value for each person/job possibility. I then add this as my commentary field in the pivot table and colour it white so that it can't be seen by any uninitiated...

Hi Skip That is an interesting solution. However it adds a new level of complexity to my knowledge. If I had any sense I would renew my knowledge of Access and store my data there. I am sometimes working with over 500,000 lines of data in Excel and the system is starting to creak!! However...

Yes you have it there

Here in simplified form is what I want in my pivot table BC CC Post Surname Commentary M1 M2 M3 Budget Actual Variance ATJ1 21205 1334522 MaXXXXX "Here be dragons" 12,895 12,895 12,895 38,687 38,684 2 OK this is not a banker!!

I have a pivot table that compares budget with actual and produces a variance. I want to add commentary on each line to explain the reason for the variance. The commentary has to keep up with changes in the pivote table so external commentary is not acceptable.

I would like to thank both of your for your information. However I must apologise for not making my needs clear in my first post. Both your answers are excellent for the internal indexing of a document so I have starred you both for your clear replies. My second post which may have crossed...

Hi Madawc Thanks for your quick response. I have examined the possibilities of "indexing" inside a word document. I may be using the wrong term. However what I want to create is a "index" of the contents of lots of word documents I have this information in the form of a table in a series...

I'm not sure if you are being too sophistated in using the =HYPERLINKS formula Name the range on the appropriate worksheet Go to where you want your hyperlink index to be Right Click Add Hyperlink Select PLACE IN THIS WORKBOOK Select the named range If the sheet name changes this will not...

Hi Everyone I am a passable Excel user but I have a word document issue. However my Word and VBA experience is minimal. If it were COBOL that might be another question :) I do not control the design of the word document but I have been asked to index each document with a selection of fields...