work

  1. W

    Alternatives to Excel as a service reporting tool

    Hi All, I hope I am posting this in the right place... My company makes complex medical devices, and for which I developed an Excel based service reporting tool. The service report does a couple of things: it guides the service engineer through exactly has to be done based on the service they...
  2. N

    AND Formula in Macro VBA

    In the below Macro, specifically the section in red, i am trying to and an AND formula but do not know how. In short, when the value is evaluated and it matches the "" "" format as shown, i need add a condition that say if the number in the cell with the offset of -5 of the row is 5080 then...
  3. D

    Selection.AutoFill Destination:=Range Question

    I recorded a macro to do an autofill, the first time it ran it only had 100 rows, but the rows count can change. How would I make this macro work depends on how many rows there are? Column A will always have the correct number of rows. Selection.AutoFill Destination:=Range("N4:N100")...
  4. Y

    Changing Cell Value Based on Another Cell Text - NOOB :(

    Hello, I'm super noob/beginner with macros and I'm writing a code to change the value for cells in column E to 0.00 if cells in column K has "Yes". Here's what I have: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$K$" And Target.Value = "Yes" Then...
  5. M

    VBA to Remove Leading Space

    I am not well versed on macros and am looking for assitance on a VBA that would remove/trim leading spaces. Cell range is A1:AU500. I've googled around and searched the boards here, but I can't quite get anything to work. Thanks for your help.
  6. J

    Login with no ID

    Hi, Want log in to a website automatically with vba but the problem I am having when I inspect the login box there's no ID HTML only what's in the picture below, tried using this line of code but doesn't work: HTMLDoc.getElementById("login").Value = Worksheets("Portal_Access").Range("F20")...
  7. W

    Worksheet Protection

    I have several protected worksheets with multiple passwords. I am not permitted to change the PW. I would like a script to unlock all the sheets so I thought of this, but it does not work. Any Ideas? Sub Un_Protect_All() awsn = ActiveSheet.Name For Each Sheet In Application.Worksheets...
  8. W

    Password unprotect sheets - multi passwords.

    I have a number of workbooks with different passwords. Sometimes worksheets within a workbook. I am not allowed to change them. So what I would like to do is loop thru all worksheets an try all the PW's But I cannot get this to work. Sub Un_Protect_All() awsn = ActiveSheet.Name For Each...
  9. S

    Getting Percentage with CountIF Formula? I think..

    Hi, I'm trying to find a logical way of doing a task that's not going to take me 100 hours, which I'm learning that this isn't a bad idea as it teaches me more and more about excel. I'm trying to the total amount of people showing up for duty on certain days. My call center sends out a...
  10. A

    Joining two IF/ AND statements

    I am trying to join two statements but keep getting errors. Please could someone help me and explain how to join them into one statement? Both Statements work correctly on their own =IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))...
  11. H

    Excel command button works on my computer, but not others

    I have a command button in my workbook, which is used to resent a column of values back to zero. The button works on both me and my husband's computers (we both have office 365, fully up to date) and also works on my intern's computer (older - office 2010). However, it does not work on my...
  12. ChuckDrago

    Counting with multiple criteria

    Hi everyone, I have been asked to provide charts for returned merchandise by return code. I initially imagined building a table where the merchandise ID was in column "A" and column "B" will have the return codes, which are A,B,C,D,E and F. Therefore to graph the results I would need to count...
  13. H

    Copy part of sheets to new workbook

    Hi all, Tried to find a solution for this but it seems I'll be the first to attempt it. I have a workbook containing several sheets, there are 7 permanent sheets that I have renamed as Sheet01 to Sheet07 and a growing number of other sheets. A macro allows the users to create a new set...
  14. A

    Page Sizing of Document Different From One Computer To Next?

    I have created a one page "form" with an Excel worksheet of my work computer. It is designed in a manner to be previewed and printed on one page without any scaling. When I take this same worksheet home and edit it, preview or print, it no longer fits within the one page originally created to...
  15. I

    SumProduct - Multiple Criteria - VBA

    I am trying to work on a set of data, where I need to count how many times certain combinations of codes are used. Originally I had just one set of codes to count, but now I have multiple code combinations to count. Is it possible to combine the two lines of code as below, to work together in...
  16. E

    Excel to return work week given criteria across multi years

    Excel 2016 (Windows) 32 bit <tbody>#E0E0F0[/URL] "] #FFFFFF[/URL] ]A #FFFFFF[/URL] ]B #FFFFFF[/URL] ]C #FFFFFF[/URL] ]D #FFFFFF[/URL] ]E #FFFFFF[/URL] ]F #FFFFFF[/URL] ]G #FFFFFF[/URL] ]H #FFFFFF[/URL] ]I #FFFFFF[/URL] ]J #FFFFFF[/URL] ]K #FFFFFF[/URL] ]L #FFFFFF[/URL] ]M...
  17. S

    Pointing to files that don't exist

    This VLOOKUP works fine. =IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"") But I need the results to be blank if there's no file with that name or if the file exists but there's no tab within the file with that name. If I could get these 2 problems worked out it...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top