case

  1. B

    Create unique "id" from codes with different cases

    Hi all I have a large table including Salesforce Id's, which are supposed to be "unique", but unfortunately also use case to make them so. The table uses data that includes a range of Salesforce Id's, from just one, to many rows with the same id. I need a way to convert these id's into truly...
  2. B

    Select Query based on day of the week

    I have a query that every day pulls yesterday's data from an sql database and drops it into Access. SELECT Date, InvoiceNo, Customer FROM SalesDatabase WHERE Date=Yesterdaysdate What I need it to do though is when today's date is a Monday, I need it to gather the data for Friday, Saturday...
  3. S

    VBA: When Sheet Changes - Issues with in cell formula

    I have some simple code that I have used previously. I have adapted to a different circumstance, however, I am not getting the desired effect. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range Rows.AutoFit On Error GoTo...
  4. L

    cells.value vs cells.formula

    Hi In this code, I do not see any difference between cell.value and cells.formula when it comes to entering a formula. They both did the same thing. Am I right? Is there any case, I have to use cells.formula instead of cells.value? Thank you very much. Sub insert_formula() Cells(11...
  5. B

    Inserting Multiple Rows In Very Large Worksheet

    Hoping someone might have some thoughts on optimizing the code below. I am inserting 5 rows each time a new employee is found. Then adding the text for the pay category. I have done some research and was wondering if "Resize" may be a viable option. Thanks, Bob X = 2 Do Until Cells(X...
  6. B

    Deleting certain rows in 95,000 row worksheet

    I am using the code below to search cells for certain criteria and then keeping certain rows and deleting certain rows. This code currently takes around 1 hour to process 95,000 records. I need help in determining if there is a better way. Thanks, 'Delete Level 1's and certain Level 2's X =...
  7. P

    Inventory VBA

    Hello, I've received and modified a simple VBA from another excel and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets. I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3...
  8. E

    How to calculate Average Handling Time (AHT

    Hello everyone, Hope you are having a great week. I am trying to figure out a way to calculate AHT (Average Handling time) for each cases irrespective of the dates. Just to summarize the table, DE stands for Data Entry. Average handling time is calculated as the total time taken to complete a...
  9. I

    Search Multiple tables on multiple worksheets - find next item.

    Morning All, I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it...
  10. A

    A further 32 to 64 bit conversion problem

    Hi, I'm using this really cool function in 32 bit Excel. It says I should not alter it.. but even if I try by just adding ptrsafe I can't get it to work. Is there a another similar routine I could use in 64 bit environment? Any help appreciated. Here is the full function. 'This code was...
  11. I

    Could you check my code, userform to worksheet please

    Hi, The code is shown below. I have a userform with Comboboxes ComboBox1 is MONTH ComboBox2 is YEAR Month is to be inserted into cell A3 Year is to be inserted into cell C3 When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3 Please can...
  12. S

    Product + Sum (if)

    It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions? MY case =PRODUCT(S15,0.3) I placed this formula in order to have the result of...
  13. A

    Extracting some data from a string in a cell

    One more help needed. In one column i have multiple email addresses of different length. For eg: amit.dhamija@rediffmail.com. How can i extract value after "@" and before "." which in this case is "rediffmail" ??
  14. D

    vba code to refresh data from OneStream

    Hi, I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this? I tried the following macro but it doesn't work: For Each cnct In ThisWorkbook.Connections Select case...
  15. L

    If value selected before,Then remove from the data validation list VBA

    Hi All, I hope that you can help me in this. I have 2 sheets, using a list of data in the other sheet to enter the data into the first sheet, I’ve used a VBA code to get a searchable list with a combobox, what I need is to get the value removed from the data validation list if used before to...
  16. L

    Assistance with a routine to be triggered based on specific days and time of the week

    Guys I developed a spreadsheet that when the file is opened it sends an e-mail after 1 minute and then it auto close the workbook. Application.OnTime Now + TimeValue("00:01:00"), "SendReport" There are certain days that I need to send the report. So I created a task scheduled on Windows to send...
  17. kelly mort

    VBA code modification to insert row to a table instead of entire worksheet

    Is there a way to add only a range of cells instead of entire row? Here, I will like to insert from Col B to Col O. I have other data adjacent the range B:O and the entire row is interfering with the layout. I will be more than happy to find a work around. Thanks in advance...
  18. D

    Selection from drop down box

    I have a drop down box on a sheet called Start_here with 2 options and each option is a town. When the option is selected and a Continue button is pressed I need a header and footer to be loaded onto the sheet quote_sheet depending on the town selected. The headers and footers are images...
  19. B

    Setting up Previous and next Buttons for search results

    Hello everyone, I have my userform almost done. I am able to do my searches, a it sorts the data properly. It will show first match in my form, but have added Prev and Next Buttons to look through similar matches. I am not sure how to get it to work with the search results. Here is a screen shot...
  20. I

    Userform opens twice

    Morning, Please could you check my code & advise a fix. I open my workbook. It defaults to INCOME (1) to open first. I see the msgbox asking me to select MONTH & YEAR I choose to select CLOSE FORM The form quickly coses then reopens. I choose to select CLOSE FORM again & it closes. Now i can do...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top