1. P

    Lookup and Find

    I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate. In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10. So an idea is as below: <tbody> Sequence...
  2. H

    VBA - User Form show at start of macro & hide at the end

    Hi, I have a user form(UserForm1) which I want to show at the start of the maro & hide at the end i.e. when the macro/code is completed. The purpose for this is that some codes do take few seconds to complete so I would want a user form (stating some text like the macro is ruuning - pls wait...
  3. A

    Formula to Return Training Status with Multiple Outputs

    I a table with 6 different input scenarios and need to return 4 different outputs depending on the input. The table data is all dates and I would like to fill the Status column with one of the following outputs. No-Value Complete On-Time Past-Due An example of the scenarios in the table...
  4. V

    Conditional formatting colour scales on different cell

    Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks <tbody> <colgroup><col><col></colgroup><tbody> Status percent complete Complete 100%...
  5. F

    Complete web data from Excel

    Hello All. I need to complete a price of different articles on a website and they give me the data in Excel. I explain: Every week they send me an Excel with different article prices and I have to update those on the web. The Excel are two columns, one with the ID field and the other with...
  6. V

    Date formula with multiple conditions and nested ifs

    Hi, I need a formula that tells me 4 options based on a date in C3: Overdue= the date has passed Approaching= date is 5 days away Pending= normal status Complete: if A1 is = Yes then Complete What I currently have is this : =If(TODAY()-C3<=5, "Aproaching","Pending") I'd be really grateful...
  7. TAPS_MikeDion

    # of labels limitation?

    Is there a maximum number of labels you can use on a form? Suddenly I cannot put any more labels on my form. I'm at around 35. Every time I either try to copy and paste a label or create one from scratch from the Toolbox I get the following errors: From the Toolbox: "Could not complete the...
  8. H

    Increase OR Decrease the complete value

    Column B is updated with RTD Output required in Column C as: If 3rd decimal place >=5, then INCREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple ELSE DECREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple Thanx in adv I am using...
  9. T

    Macro to apply formula to a range of cell

    Hi, I have written a macro to apply a formula to a range of cell the following is working just fine 'Worksheets("TRANSPORT").Range("N15:N34").Formula = "=MIN(K15,MAX(D15*I15,J15))*INDEX(ROE,MATCH(G15,DEVISE,0),3) but this formula is not the complete version that does not work Here the...
  10. J

    Toggle Button 3 options

    I need a macro to assign to an object button (Shape) when pressed it will toggle a specific cell value to change between PLANNED, IN-BUILD and COMPLETE. I have this code but it only gives me two options Any Help would be appreciated. Regards Jason Bing Private Sub CommandButton1_Click() With...
  11. L

    Shape macro

    Hi all, I am after a macro that when a button is clicked it changes the colour of a shape to say if the statement is complete, working towards or incomplete. I then need a cell to be linked to the cell so that if it is complete the cell shows 3, working towards 2, incomplete 1. I have a macro...
  12. S

    Selecting one Cell highlights all others with the same data

    Morning all I have a worksheet that contains a list of courses for 2 of my departments, Column C pertain to courses "Department A" have completed and Column G pertain to courses "Department B" have complete. There are over 450 courses detailed in each of these columns, with multiple courses of...
  13. D

    Filter data on multiple criteria

    I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table...
  14. S

    Userform Listbox Refresh

    HI Not a programmer but hopefully doing a good job of finding and playing around with code to get what I want. I've created a spreadsheet that has raw data on a worksheet. I have one macro that scans through the data and the last column (J:J) is changed to REVIEW DUE, FOLLOW-UP or COMPLETE if...
  15. S

    Schedule forecasting to maximize throughput

    I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...
  16. M

    Automatically move a row to another sheet based on cell value

    Hi there. Complete VBA and Macro novice here and I have trawled the internet trying to find a solution. I have a basic spreadsheet with 2 sheets, titled 'Active' and 'Complete'. In Sheet 1 (Active) I have data in columns A - I. Column I shows a status as either Active or Complete. I want...
  17. E

    Extract Data to Email Body (from a VBA newbie)

    Hi all, I have a form that staff complete. Cells A1:B6 contains information. I need VBA writing to complete the following: Send to designated email address Subject line to be B1 and B2 (example "Mr Smith 12 May 2019") Copy information from A1:B6 into the body of the email The user should...
  18. D

    formula to enter a % based on a word that appears in a cell

    Hi all I can't even begin to determine how to approach what I would like to happen. Can I use a formula or should I use code? I have an Inv # in col "A" and a Description in col "I". I also have a table ("wordpercent") on a sheet "Info" with a list of words - Col "N" and a corresponding % -...
  19. L

    Calculating the average handling time to complete a task

    Hi, I'm stuck with a particular kind of formula in excel. I'm looking to calculate the average amount of days it takes for a transaction to be completed for each month. I have a sheet listing when all the expressions of interest and the date/time that this occurred and another listing when the...
  20. P

    Distinct Count Formula

    Hi All, Is there a formula to find distinct count in a column without using COUNIF function. Currently I'm using the below formula, but it takes more time to complete 9000 rows of data i have. Can someone assist me on this pls. IFERROR(1/COUNTIFS(A:A,A2),"")

Some videos you may like

This Week's Hot Topics