code & formula

  1. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  2. D

    Alphabetically order a list with respect to column B

    Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David
  3. S

    Excel formula

    ABCDEFG8NATURALGAS20JULFUT#DIV/0!#DIV/0!9NATURALGAS20AUGFUT#DIV/0!#DIV/0!10NATURALGAS20JULFUT0011NATURALGAS20AUGFUT#NAME?#NAME?12NATURALGAS20JULFUT0013NATURALGAS20AUGFUT#NAME?#NAME?14NATURALGAS20JULFUT0015NATURALGAS20AUGFUT#NAME?#NAME?F8F8=IF(ALGO!E24>1.8,"SE ",IF(ALGO!E24<-1.8,"LE","No...
  4. I

    VBA Macro - Compile Error

    Hello, I am contacting you because I am trying to create my first VBA macro. But when I am trying to build it, I receive the following error. I am sure I am totally wrong when it comes to the code as it is the first one I am building. If any excel expert could help me to understand what is wrong...
  5. B

    VBA Rolling Date

    Hello, I am trying to figure out how I can have VBA insert today's current date into a specific cell. For example in cell A28 we have our start date as 3/9/2020, cell A29 is 3/10/2020, A30 is 3/11/2020 and so on. I only need Weekdays to be included and not Weekends. I know this can be done...
  6. J

    Comment Section to Categorical Data (Columns)

    Good Morning All, As always, I must start out my posts with a big thank you to everyone who contributes to this forum. So I have a bunch of data in various columns with only one column I need to convert to categorical data. Column H is what I will need the script to focus on. I have a...
  7. L

    VBA help needed please - splitting date range into monthly values!

    Hey guys, First post here so please forgive me if I miss anything.. I am new to VBA and attempting to find some coding that will allow me to allocate the below section units between months based on course start and end dates. I have entered a couple of lines below of what I'm working with. It...
  8. J

    What's wrong with my code?

    Hi guys, I've been building some code for a spreadsheet which has a whole host of individual weighted words. When a user types in a particular sentence into the (Sheet: tester) "Search_box1" field, upon clicking a button I want each word in "search_box1" to be referenced in a separate sheet...
  9. L

    Sum if / Group by VBA Module

    Hi All, I have a module written to pull data from one sheet (Raw Data) and into another (Opportunities). But I am having trouble with the last piece. I THINK I need to group by Column B in Raw Data - but I still want to sum by Column C in Raw Data. Not sure if that is correct, but I was able...
  10. E

    Timesheet Form

    Hello How are you my friends! I hope you will help me to complete this table It is a Time sheet I want you to create numbers of work time according to the following condition: in (E8) set valuein [F8:AJ8] random numbers SUM random numbers in [F8:AJ8]= SET VALUE in (E8)I want to cancel...
  11. G

    Sum of coding variable by using Index and Match

    Dear all, This is my first time here. Could you please advice me with this question? I already try to search but couldn't find the answer. Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0)...
  12. G

    Sum of coding variable by using Index and Match

    Dear all, This is my first time here. Could you please advice me with this question? Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0). And I want to sum all of 15 questions in another...
  13. J

    Complex Sorting Macro for names & emails

    Good Morning All, As always I like to start off my posts with saying thank you to everyone who responds and provides assistance. I have a tough one to crack...I need to create a code/script that sorts 5 columns of data. First column is (A) last name, first name (exact format). Second column (B)...
  14. J

    VBA Code for searching exact text with or without spacing

    Hello all, Please help. So I have one column of information that is inconsistent to say the least. It has different spacing, hyphens, wording. Essentially it is a comment box filled with different information. What I need is a script or mechanism to only search certain numbers and text 1) 2...
  15. Eikon

    Command button (Active X) multiple tasks

    I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...
  16. Eikon

    Command button (Active X) multiple tasks

    I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...
  17. R

    Insert formula every nth Row?

    From Columns AN to BB (15 columns in total), I have a match/index formula that needs to be inserted every 11th row. Does anyone know of a VBA code to perform this? Note: each of the 15 column is a unique match/index formula catered to that specific column cell. Thank you in advance, Kim
  18. E

    2 Issues: Inefficient Array Read/Write Procedure & Compile Error Procedure Too Large

    Hi, I'm having two issues with my code: the first is, I'm trying to match part numbers I pull in from a database to excel with a part description master; the second is I'm now receiving an error that my procedure is too large to compile. Background on the first issue: I receive a text...
  19. M

    How to remove (blank) from Power BI Desktop tile

    Hi Does anyone know how to remove (Blank) from a tile when no data is present and replace with a zero? im new to the tool so any help will be greatly appreciated Rosco
  20. S

    Help with vba macro for auto generating unique ID number

    I am a pharmacy student in serious need of help for my internship. I need a macro/vba code that auto generates when there is cell content in a row of a worksheet. this number is going to be an invoice number. I current have a 'masterfile' that records all finalized orders for each facility...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top