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!

Register Log in
  • Congratulations Rhinorhino 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. genuineblonde

    Pivot Table Normilize More than 2 Variable

    I have table organized as below: Plant Product Jan-05 Feb-05 Mar-05 ..... GA a 10 12 3 GA b 19 5 63 SC a 20 38 25 How do I get the data normalized? I know how to do for one variable, but not two?
  2. genuineblonde

    Automate Page Breaks in Excel

    Could it be that you have the first line identified to repeat in the Page Setup?
  3. genuineblonde

    Import View in Excel

    I am trying to import a Notes View into Excel using Microsoft Query. The Query work, but the numeric and date field come in a text. I need to be able to use in calculation. Since someone else will be using the data, I am hoping to get the data corrected coming in. The is a file that will be...
  4. genuineblonde

    Conversion

    The data is stored in a Notes database, I am using Microsoft query to download the data into a spreadsheet. However, the data has to be converted because it all comes in as text rather than numeric. The SQL statements are generated when I create the query, so I haven't stored the data anywhere.
  5. genuineblonde

    Conversion

    I am a major newbie...so please be gentle. I have the following select statements. SELECT Download_Schedule.Machine, Download_Schedule.EndDateTime, Download_Schedule.ordnumber, Download_Schedule.customer, Download_Schedule.Qty, Download_Schedule.brand, Download_Schedule.BagSpecNo...
  6. genuineblonde

    Problem changing formatting for some cells

    On a chart, I have linked to a worksheet cell in a text box. Can I {how} change the alignment,font of the resulting text in box?
  7. genuineblonde

    Currency Format Word Table

    I was trying to avoid having to lock the form. The user needs to be able to insert and delete rows in the table.
  8. genuineblonde

    Currency Format Word Table

    How can automatically format an entry into a Word table to the currency format? Example: Enter 6957.11 Desired Display Result $6,957.11
  9. genuineblonde

    Automate Page Breaks in Excel

    Hi, I appreciate your help...however I am getting the following when I try to run the macro (2nd option). Runtime error '1004' Unable to set the pagebreak property of the range class. The range I am breaking on is a person name.
  10. genuineblonde

    Automate Page Breaks in Excel

    I have a worksheet with several columns of data, sorted by column A. Is there a way to insert a page break automatically whenever the value changes in column A?
  11. genuineblonde

    Spell Checker on a Protected Form

    I have a protected Excel Worksheet...how can a user's spell check?
  12. genuineblonde

    Project Central Start Finish Dates

    I am new to using Project Central. How do I enable my resources to change the start, finish or duration time for a task?
  13. genuineblonde

    Conditional Numeric Format

    I want to calculate the newworkingdays between two dates. If the answer is 1, then format the ## day otherwise format the cell ## days. I am using Excel 2002. Any help is appreciated.
  14. genuineblonde

    Elapsed Worktime Calculation

    Can anyone help me with a formula to calculate elasped work time? The time is for a group working a five day schedule Monday to Friday, Hours 8:00 AM To 5:00 PM. The data is currently arranged with the start date in one cell and start time in a second cell, but they can be combined. The...
  15. genuineblonde

    Populate a list base on Rating

    It needs to fully automated. Thanks for the suggestion on the Autofilter, but it needs to be a separate list in another area of the worksheet.
  16. genuineblonde

    Populate a list base on Rating

    I have 2 column list. Column A has employee ranking. Column B has employee names. I need to pull the names of the employees with "Excellent" Ranking to another worksheet. Can anyone help me with the formula to use? I don't want to use a VB.
  17. genuineblonde

    2 up printing

    I am trying to print to a HP 8150N. I would like to take a document that is currently printing portrait 2 pages and print it landscape on one page (page 1 & 2 side by side. Any help would be greatly appreciated.
  18. genuineblonde

    One data point at the intersecttion of two values

    I want the x axis to be the sale values, the y axis the DPC value. Place one point at the intersection of the values for SJA and label the data point SJA.
  19. genuineblonde

    One data point at the intersecttion of two values

    How do I create a chart that represents one data point at the intersection a an x and y value Example Name Sales DPC SJA 1000 200 JWE 2500 400 KOP 1500 300 I want to graph the intersection sales and DPC with the name beside the data point.
  20. genuineblonde

    Import Specification for Query

    How do I define a field as numeric when using Query to import a field? Currently the field comes in as text. I can't change the data source, which is a Lotus Notes Database.

Part and Inventory Search

Back
Top