help

  1. D

    Ideas on how to track inventory expiration dates

    NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...
  2. D

    Excel conditional formatting does not work!

    Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
  3. B

    VBA Coding, need help!

    Hi! I am currently trying to figure out a VBA code (I’m not super familiar, but can grasp concept with little experience I have): The coding is for a training tracking sheet. I have a date in one cell, that will get over-written each year with the new training date. the next cell over...
  4. B

    Expiry Date IFTHEN?

    Hi! I am trying to figure out a formula for the following (hopefully I explain it correctly) I currently have a sheet where the date of training is entered, and the expiry date is then auto-filled based on the first of the next month of the following year (some have 2 year anniversary dates)...
  5. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  6. L

    Hi i need some help for my assignment on savings/investments!!

    Im really new to Excel and I do not know how to start on this assignment.. Anyone knows how to do this? Im not concered about the influence diagram.
  7. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  8. D

    VBA code not working anymore?

    Hello everybody, I am currently managing a stock tracking file, which is edited manually to a large extent. Currently, the four significant columns look like this: Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...
  9. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  10. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  11. D

    We found a problem with some content in "File name". Excel annoying message

    Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...
  12. G

    Pull text fro another list

    Hi all, I have a workbook containing, for example: Worksheet 1: Sensor ID | Location | Column C | etc | Master: Sensor ID | Column B | Location | etc | The "Location" on the first worksheet is blank. I therefore want to do the following: In column B on Worksheet 1 I want it to pull the...
  13. D

    Freeze panes for titles below row 1

    Hello everybody, Is there a way to freeze the title panes below? It seems to be that I can only freeze top and right side panes. I want to freeze these 5 panes here, so once I scroll down below A13-E13 they keep up with me.
  14. D

    Have one cell check whenever data in another cell changes for entire column

    Hello everybody, I am currently managing a database full of stock quantities, here: Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for...
  15. D

    Run-time error "53": File not found

    Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...
  16. D

    Pivot table solution? Please help!

    Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...
  17. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  18. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  19. R

    VBA Comparing Name on schedule to vacation list

    I'm hoping someone on here can help we with what I'm trying to create in our Excel work schedule. In the Sheet "Availability" it lists all of the employee's in Column B. With the date listed in Row 2. In the Sheet "Assignments" is where we enter each employee's assignment for that day (Date is...
  20. Ramballah

    Stupid calculation I can't figure out...

    Hello everyone, Today I have come across a very stupid calculation which I just cannot figure out how to solve. I already feel dumb enough as it is so yeah here goes: The table on the right is where I fill in all the "resources" I have (this is for a game, I'm sorry if this isn't meant for any...

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