Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jaks999

    Quick Access Toolbar in Excel 2007

    I want to copy everything I have in the Quick Access Toolbar which includes about 10 buttons connected by my personal worksheet and another 15 or so commands that I use regularly. Lately, it seems to be regular occurance that I have setup (my) excel again - whether it is for a new computer or...
  2. jaks999

    Quick Access Toolbar in Excel 2007

    I've setup my excel quick access toolbars with a number of general shortcuts that I use regularly as well as a lot of macros connected to my personal workbook Can anyone tell me how to copy the quick access toolbar in Excel 2007 so that I can copy the setup I have to another computer? Cheers...
  3. jaks999

    Pivot Table - setting sum versus count

    to Skip & Ken, Thanks for the comments - that helped me sort my problem out. Cheers,
  4. jaks999

    Pivot Table - setting sum versus count

    I have the following procedure for creating a pivot table. Normally it works fine and produces a "Sum of balance" in the data area. However, every now and then, on data in a new spreadsheet, it does a "Count" of the data instead of the "Sum" Why does it do this and how can I ensure that it...
  5. jaks999

    After SP3 program trying to access e-mail addresses in Outlook

    Hello, Ever since I installed Office XP SP3, whenever I click on a new email message, I get a pop-up that says "A Program in trying to access the e-mail addresses in Outlook - do you want to allow access?" When I click "No", the word editor starts up normally for a new email message. I have...
  6. jaks999

    How to enter a complex concatenation formula

    Hello pcmedic411, Yes your solution was helpful, and I used it for another formula that I needed to record. However, for the problem I wrote about, I decided to setup a cell with the formula that I could copy from, instead of creating and inserting the formula using VBA. Sorry for the late...
  7. jaks999

    How to enter a complex concatenation formula

    I have a column of payroll code data consisting of 12 character in column B, as follows: "010203RP0001" which needs to be expanded into an account code, in column C, of the following format: "01.02.03.00.00.00.11900.0001" My formula to create this is as follows...

Part and Inventory Search

Back
Top