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

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

    Extremely slow VBA code

    I have some code that does the job, but takes over twenty minutes to run. The code works on 10,000 lines of data on an excel tab and cleans it up (deleting some columns and also all teh blank rows etc and then moving it to a new tab), I do have application.screenupdating set to false and I have...
  2. Queryman

    Sumproduct using multiple colums for criteria and summing

    I have my data laid out like this A B C D...... Administrative 100 Group Meetings 200 .... Bereavement 105 Group Meetings 5..... Group Meetings 105 Administrative 200..... I need to use sumproduct to add the values in col B,D,F,H & J like below. Please...
  3. Queryman

    VBA BeforeClose problem

    I have several workbooks that are formatted the same, but have different data. I have a userform that shows up for two seconds when the workbooks are closed. I am now changing the workbooks using only code and want to save and close them, but that triggers the showing of the user form. Since I...
  4. Queryman

    Excel Ranking Macro

    I often have to create ranks in Excel and it's time consuming when there are multiple rows of ranks based on Regional performance versus Divisional performance. I was wondering whether anyone has some code that they could share that would help in this process. I am thinking that if the code will...
  5. Queryman

    Copying Column Selected into code

    I have a VBA routine that lets user select a column Sub getcolumns() Dim userRange As RANGE, output As String 'get a range from the user via an input box On Error Resume Next Set userRange = Application.InputBox( _ prompt:="Select cells on a single column for processing", _...
  6. Queryman

    VBA question on Merging data from two sheets

    I have a macro that works well in merging data from similarly formatted files (each with different data) in a folder. It extracts data from a certain sheet from each file and then merges them into one excel worksheet. I need a change made to this macro and not sure how to do this. Currently the...
  7. Queryman

    Validation Dependent list based on two other lists

    I have a list with 10 values in a cell, let's say cell A2, and another list with 8 values in the next cell B2, is it possible to have a third list in the adjoining cell C2 that will only have a list if specific values from list a and list b are chosen and no list if those specific values are not...
  8. Queryman

    Data Validation

    I have cells in a column that has data validation and point to a list with two values "HERE" and "GONE". I want this list to only appear for the user if the criteria in two other cells equal certain values. I tried this =IF(AND(C2="IN",D2="OUT"),STATUS,"") in the cell's data validation under the...
  9. Queryman

    Outlook email attachments saved to hard drive MACRO not working

    I have code that pulls all the attachments from a subfolder in my Outlook inbox and saves it to my hard drive, works great, but only seems to pull the oldest file in cases where there are duplicate file sent by the same person. Does anyone know using the following macro how to pull just the...
  10. Queryman

    Change Option button value

    I have four option button on a form and when checked they have a value of "TRUE" and "FALSE" when they don't. I need the TRUE and FALSE value to convert to LOYAL and NOTLOYAL. The code I wrote is not working, any suggestions will be highly appreciated. If OptPreLoyal.Value = True And...
  11. Queryman

    Form based excel input

    I urgently need to create the following: Excel workbook with two tabs, the 1st tab will only show a form for input with the following inputs: 1. Program Type (pick from list) 2. Product(pick from list) 3. Date 4. Estimated cost ($ format with 2 decimals) 5. Actual cost ($ format with 2 decimals)...
  12. Queryman

    Form based input in Excel, locked worksheet

    I urgently need to create the following: Excel workbook with two tabs, the 1st tab will only show a form for input with the following inputs: 1. Program Type (pick from list) 2. Product(pick from list) 3. Date 4. Estimated cost ($ format with 2 decimals) 5. Actual cost ($ format with 2 decimals)...
  13. Queryman

    Email 350 different excel files to 350 different emails

    I need to distribute 350 different files to 350 email addresses in my company, is there an excel macro that can handle this? I can create an excel file that would have the email address of the person and the name of the file they would receive in two columns, can that be used to feed the macro...
  14. Queryman

    Upper row and column limit in an access 2000 table

    Does anyone know the upper limit for rows and columns in an access 2000 table Michael
  15. Queryman

    Dynaic drop down list boxes for data validation

    I have a list box with five unique items, currently I have them in one list and there is another list box with about 20000 percentages that I am using. What I need to do is for each of the five items on the 1st list, have the second list box dynamically list anywhere from 1 to 20000...
  16. Queryman

    Hide & display rows in excel with locked cells

    I need to lock certain cells but also have the ability to have the user hide or display the rows with the locked cells. Is that possible with VBA using a macro button? Michael
  17. Queryman

    Excel- calculated cell from drop down boxes to be moved

    I have a worksheet that has several drop down boxes, the user gets to choose a single value from each list and then a calculation is done in excel on a cell which displays the value of the combination of the users choices. I need a method to move that value to a different cell in the same...
  18. Queryman

    Creating Subtotals & Grand Total in Answer set

    I have a query that I am going to give to an user who is not that technically inclined. He will be using Queryman. The query retrieves some values from Teradata, but the end report the user wants needs to have subtotals and grand total for the first field in the query, there are sixteen unique...
  19. Queryman

    Filter Bad data in Excel

    I have a excel worksheet that I receive frequently, it has the following columns of data CLIENT_NAME $10, SEGMENT $54, ANALYSIS_YEAR $4, STRUCTURE_CODE $8, INCLUDE $7, OPERATIONAL_ID $15, ANALYST $25 The data is all characters noted by the "$" and the number following is the number of...
  20. Queryman

    Invalid data filter

    I have a data set which could have invalid characters I need to take every obs which has a invalid character like &! etc and put the whole obs in data set and the rest in another. Here is what I have so far proc sql ; create table structures2 as select...

Part and Inventory Search

Back
Top