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 derfloh 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. jeffm777

    Find differences between cells

    Ok I'm stuck and need some assistance. I have a spreadsheet that has invoice numbers in column A and the reason the product was returned in Column B. Some invoices appear more than once on the sheet depending on how many products were returned on that invoice. I'm trying to find invoices...
  2. jeffm777

    Add field headings to multiple fields at once - CR11

    I have an existing report that I need to add headings to for all the fields on the report. There are dozens of fields and the spacing is bad between the fields so I can't easily see the field names. Is there a way to add the headings for all fields at once so I can export it to Excel and get...
  3. jeffm777

    Excel 2007 - Copy last word in a cell to another cell

    Awesome! Thanks - works like a charm.
  4. jeffm777

    Excel 2007 - Copy last word in a cell to another cell

    I have a string of data in cell A1... XXX.AD1212,super,6ft,black I need a formula to move the last word in this string to cell B1. Here's the kicker...sometimes there will be commas separating the data in the string, sometimes it will be spaces, and the number of commas and spaces will vary...
  5. jeffm777

    Wrap column of data to multiple columns at page breaks

    Using Excel 2007... I have a spreadsheet with 3032 rows of text in column A. I'm repeating row $1:$1 on all pages. There are 10 columns (A thru J) on each page and 47 rows including the row I'm repeating on all pages. What I want to do is move cells A48:A93 to B1:B47, A94:139 to C1:C47, etc...
  6. jeffm777

    Excel 2007 - Remove duplicate values when importing data from ODBC

    Thanks. Worked like a charm!
  7. jeffm777

    Excel 2007 - Remove duplicate values when importing data from ODBC

    SELECT Inventory.Location FROM SQLUser.Inventory Inventory
  8. jeffm777

    Excel 2007 - Remove duplicate values when importing data from ODBC

    I want to create a drop down list from a named range. This named range will be a list of inventory locations from an ODBC query into my inventory. Problem is, I need this list to only show unique values. Also, I have the ODBC query set to automatically refresh upon opening the spreadsheet so...
  9. jeffm777

    Excel 2007 - creating a new list by matching data in separate columns

    Column A will not always equal column G. I'm attaching the spreadsheet so you can see what I'm working on. I know the index and match formula will work - I just can't figure out how to do it.http://www.homesintheshoals.com/Customer_List.xlsx
  10. jeffm777

    Excel 2007 - creating a new list by matching data in separate columns

    I have a spreadsheet I need some help with. I'm pretty sure I need to use the index and match functions but I can't figure it out. I have a list of customer numbers in column A and in column G. If the customer numbers in these two columns match, I need to replace the customer number in column...
  11. jeffm777

    Group data from excel query - Office 2007

    I have a spreadsheet that shows sales information for the 3rd quarter of 2012. Each row of data shows a customer number, customer name, address, city, state zip, and sales total for each invoice. What I need to do is group this data by customer number and show the total sales for each...
  12. jeffm777

    How to add a "NULL" option to a dynamic parameter

    Ok. Thanks for the reply but need some help as I'm not too savy with Commands. Here's what I've done thus far... I created the command and it compiled and I ignored the link warnings. I have the command in my list of database fields and I have created a dynamic parameter pulling in the field...
  13. jeffm777

    How to add a "NULL" option to a dynamic parameter

    I have a parameter where I need to include a NULL option into the dynamic parameter. The field that includes the NULL values is a string. For example, I want the Available Values option of the parameter to show... NULL Andy Jeff Bill Carl Eddie
  14. jeffm777

    Locally installed network printers show offline after reboot

    I have a customer who has two printers, one is a thermal label printer and one is an Okidata 320 dot matrix. Both printers are physically installed on Windows XP Pro SP3 PC's and are shared. They have an inventory management system installed on a Windows 7 Professional 64 bit PC and both of...
  15. jeffm777

    Excel 2007 - Page Break on Cell Change

    In column A, I have employees like AMY, DANIEL, etc. I have the spreadsheet sorted by Column A so I need a page break between employees so each employee has their own page when the spreadsheet is printed. I thought about doing a query on individual worksheets for each employee but was hoping...
  16. jeffm777

    Excel 2007 - Page Break on Cell Change

    Is there any way to insert a page break when the data in cell A1 changes (except for the header of course)? This is data being pulled from an ODBC connection to a SQL database and will be run on a monthly basis so when the worksheet is refreshed, I'll need the page breaks to automatically shift...
  17. jeffm777

    HELP extracting text from a text field - CR11

    Thanks Brian. That works but the results aren't always going to be numeric. Some will end with one or two characters so it's returning incorrect data on those.
  18. jeffm777

    HELP extracting text from a text field - CR11

    Where {@part-IC_fron_text} is mid({Sheet1_.Text},44)
  19. jeffm777

    HELP extracting text from a text field - CR11

    On your second formula, I could do another formula on the same text field like... left({@part-IC_from_text},4) and then concatenate them back together to give me my results. Do you see an easier way?
  20. jeffm777

    HELP extracting text from a text field - CR11

    The first formula is returning the following error..."Start position is less than 1 or not an integer". I used the following formula.... //{@takemiddle} numbervar hyp := instr({Sheet1_.Text},"-")-3; numbervar spa := instr({Sheet1_.Text}," "); MID({Sheet1_.Text},hyp,spa) The second formula...

Part and Inventory Search

Back
Top