fedds2

  1. F

    HELP - Error when Using FOR loops between worksheets

    I have 2 worksheets in a workbook. I want to use 3 columns (ex col 3, 5, 7) in say row1 in worksheet1 to compare with 3 columns in worksheet 2. The process would be to cycle through the worksheet 2 comparing the columns. If they are the same, then copy a data value from a specific column in...
  2. F

    copy a range from multiple worksheets to one worksheet

    I have a macro which inputs QC data as a text file then creates separate worksheets for each QC. It then calculates mean, SD and CV for the different analytes. The number of analytes can vary. This coding although crude works well. I now want to create a summary sheet in order to print out the...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top