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!

Recent content by jwpiii

  1. jwpiii

    Excel - Merge or Join data from 2 lists

    By Bob I think you got it!! That is exactly what I need to accomplish and in only 23 lines of code. I shall output the 2 reports, create a test workbook and commence to totally confuse myself. I'm sure I shall have a question or two before all is said and done. Off I go to edumacate myself...
  2. jwpiii

    Excel - Merge or Join data from 2 lists

    Thanks for the suggestions and my apologies for the delay in responding. To accomplish my goal of keeping user interaction with the workbook to a minimum, I am going to try my hand at a VBA routine that will merge or join the two lists automatically. Failing that then I will probably try...
  3. jwpiii

    Excel - Merge or Join data from 2 lists

    Thanks again, sorry for the delay as I was in meetings the rest of the day and this morning. To reduce the interaction from the users of the analysis workbook rather than use MS Query I am going to try my hand at a VBA routine that will merge or join the two list automatically. John
  4. jwpiii

    Excel - Merge or Join data from 2 lists

    Skip, Thanks for the reply. I looked briefly at MS Query and at first glance it appears that the data in the report that is generated which my workbook would pull from in it's native format was not readable by MS Query. I recieve an error that the data source contains no visible tables. I...
  5. jwpiii

    Excel - Merge or Join data from 2 lists

    While I'm sure that this question has been asked and answered previously, I was unable to find the solution in FAQ's or searching previous threads. I also posted this in the Office forum and after countless hours of searching now think that it may be a VBA solution, hence my posting it here. I...
  6. jwpiii

    Excel - Merge or Join data from 2 lists

    While I'm sure that this question has been asked and answered previously, I was unable to find the solution in FAQ's or searching previous threads. I have two different reports that are output to an Excel format from another piece of software. The format of the reports are the same and some of...
  7. jwpiii

    Excel Print Range Question

    Problem Solved!! I posted this same question in the Visual Basic Forum, and Loomah posted the solution for me. Thanks for looking
  8. jwpiii

    Excel Print Range Question

    Loomah Thank you!! Thank you!! I had already recorded the macro using the full print range. I made the change you provided for the print area. For testing purposes, I chose an option (in another area that generates the report and thus controls length) that would result in a 3 page report...
  9. jwpiii

    Excel Print Range Question

    I posted this in the Office Forum, but I think it may be better suited to this forum. While I am not a programmer, and I am sure there are much better ways to complete this task, here is what I have done. I need to print a report that may be 1 to 5 pages in length. The data for the report is...
  10. jwpiii

    Excel Print Range Question

    While I am not a programmer, and I am sure there are much better ways to complete this task, here is what I have done. I need to print a report that may be 1 to 5 pages in length. The data for the report is to be displayed in a template that I have created in columns ek thru ez. I have copied...
  11. jwpiii

    Excel Sum with Multiple Conditions

    Thanks for the help, here is the formula that I am using currently. Are there any draw backs to it's usage? =SUM(IF(W3:W500=&quot;Open&quot;,IF(F3:F500<=(TODAY()-AA19),E3:E500,0),0)) In the formula, AA19 contains the number of days to base the calculation on per user input.
  12. jwpiii

    Excel Sum with Multiple Conditions

    Need to do a sum with multiple conditions. 1st condition is column W equals &quot;Open&quot; then second condition is a calculation of Column F is date is 20 days or more before todays date. I need to sum column E for those totals in which both conditions are true. My range is row 3 through...
  13. jwpiii

    Calculating a Cell Location in Excel 2000 - Help??

    Zathras, Thank you!! Thank you!! Can't tell you how many hours I wasted trying to figure this out. Next time, I will abide by the fifteen minute rule: If you don't figure it out in fifteen minutes, ask for help!. I'm not to proud to admit my faults... Thanks again... John
  14. jwpiii

    Calculating a Cell Location in Excel 2000 - Help??

    while I know that the ultimate solution to my project is to use Access, I have created an Excel spreadsheet for short term use while I work to develop the Access product. In Excel, I am using a section of the sheet as a table like in Access, with the rows representing the records. I have an...
See more

Part and Inventory Search

Back
Top