release

  1. I

    Are there any differences between these two ways of typing a shortcut?

    Hi guys, If I want to paste something as value, I can press Alt + ESV. That is, hold Alt and press and release e, press and release s, press and release v. It did the trick. However, I just found I can also press Alt and release it, press and release e, press and release s, press and release v...
  2. S

    how to prepare a table for 6 locations, 10 destinations, 8 items and 550+ order numbers...

    Hi all, I have 6 locations (LOC1,LOC2,LOC3,....), 10 destinations (DEST1,DEST2,DEST3,.....) and 8 items (ITEM1,ITEM2, ITEM3,...). To release ANY item from ANY location to ANY destination separate "Release Orders" (R.O) are used. The list of all R.O goes to above 550 lines which makes finding a...
  3. C

    Conditional Formatting

    Ladies and Gentlemen, I have just taken 2 excel courses and I was unable to figure out how to do this based on the knowledge I received. I work for a construction company and I am trying to make life easier for us all. I have a table with 3 columns. Column 1 - "Due Date" (This is the date in...
  4. B

    Project Tracker

    Hello all, I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers. Calculate released quantities against the estimated beginning quantity to know how much remains...
  5. M

    Calculate Dates and Shift

    Hi I'm trying to Count Release Date and Release Shift Based on Time of Sampling Release Date will be 27 hours after the time of Sampling Shift to be decided by time boundaries (If time is between 0800 and 1600, shift A, 1600 to 2400 Shift B, 0000 to 0800 Shift C.) If after 27 hours Sunday has...
  6. P

    Conditional Formatting Based on 2 cells

    Hi, I'm wondering if someone can help me? I'm trying to write a formula to highlight the tender release date on a spreadsheet. I've got as far as being able to highlight a line where the cell states "Tender Release" (=OR($D$141="Tender Release") but I need to add to this a condition to only...
  7. S

    How to set date not occur on weekend

    <tbody> A B C D E F 1 Name Date Start Punishment Discount Punishment Date Release 2 Prisoner A 13 Jul 17 90 Days 30 Days 60 Days 10 Sept 17 3 Prisoner B 26 Jul 17 80 Days 27 Days 53 Days 16 Sept 17 </tbody> Hi Mate These time i was working to make some prison...
  8. M

    Complicated counting

    Hey Guys, here at the company, we used to release shipping containers according to references. We have a simple sheet where we used to write released containers. The problem is that there are really a lot of references and we need to keep track how many containers we need to release and because...
  9. L

    Question on importance of releasing variables..

    My question is really how important is this? I am a real newbie so I haven't really done this before. I recently created a fairly complex (for me) workbook. And it has many (maybe 30) public variables which are used and changed at various points in the code. Recently this workbook has been...
  10. S

    Release memory (set object = nothing), but where?

    I've got the code below and i want to release memory from objCommand (set objcommand = nothing), but where can I do this? If I do it inside the "If .. Then .. End If" then it wont be executed if the if-sentence is false and I can't do it after the if-sentence because I have to make a new command...
  11. Roderick_E

    Info function in VBA macro

    Ok, I looked & looked on the internet to figure out how to use the INFO("release") in a macro. I want something like, If info("release")="0" then 'do some stuff else 'do some other stuff endif Thanks for the help

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top