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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top