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 wOOdy-Soft 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: *

  • Users: aprunkard
  • Content: Threads
  • Order by date
  1. aprunkard

    Make Mailings Addresses go Across in Excel instead of down...

    My addresses are listed like this... Mcdonald's Restaurants 826 West Walnut Street Johnson City, TN 37604 423-928-8838 Email: business profile | phone phone | map & details http://www.mcdonalds.com/usa.html...
  2. aprunkard

    MS Outlook Web Access

    I use MS Outlook Web Access for my work email now. I am running Vista with Internet Explorer 7.0. I can get logged in just fine, view mail, receive mail, but I can only send mail with a subject line. The box where you would normally type a message is not available to type in, it just has the...
  3. aprunkard

    Error when trying to play DVD in Windows Media 11

    I am running Windows Media 11 on Vista. I just recently upgraded to Vista from XP. With XP I had no problem playing DVD's. When I try to play ANY DVD now in Vista I get an error: Windows Media Player cannot play DVD vide. You might need to adjust your Windows display settings. Open display...
  4. aprunkard

    Adobe Acrobat Standard 6.0

    Has anyone been able to get Adobe to work with Vista? With XP I could print directly to Adobe from Word and Excel and now it won't let me. It doesn't give me an error if just says error in the print que. I don't want to pay the $160 upgrade fee. Thanks!
  5. aprunkard

    PivotTable Summing/Totals Formatting

    I have a data sheet that I am trying to create a PivotTable from. I have the following Columns: Campaign|Client| Date |Price|ClientLeads|Revenue (Text) (Text)(mm/dd/yy) ($) (#) ($) I want the PivotTable to look like this: Month (Using Grouped Dates) Client1...
  6. aprunkard

    PivotTable Date Formating

    I have a PivotTable based on a Data sheet that contains dates. I have tried formating those dates everyway possible and I can't get the month to appear as mmmm when I group the individual dates into months on the PT. I have tried formating the cell in the PT and that doesn't work either. It...
  7. aprunkard

    Auto Calculation Doesn't Move, Calc Sheet Works fine...

    I have a six sheet workbook. Four of the sheets have some multi-critera VLOOKUP formulas and one of them has less then 500 rows of data but three IF formulas per row. I turned off the auto calc to add some data to main sheet b/c it would take a while for the other sheets to update. But when I...
  8. aprunkard

    Sharing an Excel File from a Server Location

    I don't if this is possible or not or if we are doing something wrong. I have shared an Excel on a Network server before but is it possible or how can you share a file that is just saved on a server. When I set the file to Shared when one person has it open it says FileName.xls [Shared], but...
  9. aprunkard

    Conditional Sums Using Multiple Criteria Error

    I am trying to create a formula that sums the Revenue Column (Range Named "Revenue"), only if the Named Ranges Client="CR" AND Campaign="PCR". I have tried: {=SUM((Client="CR")*(Campaign="PCR")*Revenue)} I get a #NUM! error I have tried not using an array and I get a result but it's not...
  10. aprunkard

    Windows wants to install duplicate updates

    Windows keeps wanting to install updates that have already been installed. For example, I am prompted to download and install updates; I do and then it reboots. When Windows comes up back it says that the same update needs to be installed. When I look at my Update history on Windows website it...
  11. aprunkard

    Cannot reference cell from another workbook

    I cannot get Excel to reference a cell from a different workbook. Even if I create a formula in one workbook and cut or copy it to a different workbook it changes the references to the cells in the workbook that the formula was pasted in. What am I doing wrong??
  12. aprunkard

    Is there a need for forms and spreadsheet creators?

    I have recently quit my position as the administrative assistant to the owner of a car dealership, due to ethical differences. I excel in creating forms, spreadsheets, and presentations. I have had numerous compliments about the business forms I have created in this job and previous ones. I...
  13. aprunkard

    Can't Completely Delete Macro

    I am so frustrated with this... I have looked at every thread I could find on this... I have a workbook that intial had a Macro to Protect/Unprotect all of the sheets at once. I have tried delete the Module from VBE. I have no code on of the worksheets. I have tried to copy the content on one...
  14. aprunkard

    '<filename.xls>' cannot be accessed. Error when Excel file is emailed.

    We have a spreadsheet that is updated nightly and emailed to the owner. This file can be emailed to him with no problems from our main store but when the file is emailed to him from our second store the file will not open and you get the following message: '<filename>.xls' cannot be accessed...
  15. aprunkard

    &quot;Wait List Screen&quot; for customer appointments - need ideas/suggestions

    I work at a car dealership that sets customer appointments. My dealership owner has a large flat screen TV setup next to the main entrance that he would like to show the appointment list for the day. I could easily do this using PowerPoint but this will need to be EASILY updated throughout the...
  16. aprunkard

    Count only days equal to or prior to today Excel

    I know this has got to be simple but I am pulling my hair out trying... I want to only count dates that are equal to today and prior to today. My Dates start in A4 and whenever there is an appointment set a line is added. On a separate sheet I want to count all of the appointments that are for...
  17. aprunkard

    Creating a Training Log Database

    I am trying to create a database that keeps track of all of the dealership's employee training. I have multiple courses that will be completed on different dates by different employees. I thought I was on the right track but I can't get my queries to work. I have a table made that will store...
  18. aprunkard

    Prevent duplicate entires in Excel

    Is there a way to prevent duplicate entries in a column in Excel? I know how to find duplicates, but I want to prevent them. I'm looking to use this in a spreadsheet that will be used to keep the VIN numbers of vehicles in stock. Thanks!
  19. aprunkard

    always open new session of IE??

    When I have more than one session of Internet Explorer open and I click on a link, like a desktop icon that is a website, it always opens it in the left most session of the Explorer I already have open; logging me out of that session. Is there any setting anywhere that I can tell it to always...
  20. aprunkard

    Always open to specified sheet in Excel

    I know I have done this before but I have lost the sheet with the code in it... I want my workbook to always open to "Start Here" sheet. I know it's simple. Thanks!!

Part and Inventory Search

Back
Top