pin

  1. R

    Put in "PIN" change to Initial

    Ok, so I know how to do this using a back page sheet =IFS(Sheet2!B1=1234,"GM",Sheet2!B1=2345,"AP",Sheet2!B1=FALSE,"") But what I ultimately need and can't figure out is how to do this in the same cell. Rather than typing the "PIN" in Sheet2 B1 to input the initial in Sheet 1 M2, I need to be...
  2. I

    Code not working as it should

    Morning, I have a userform which after selecting from a drop down list its then sent to my worksheet. ComboBox5 has the options as follows, 1 2 3 OLD 3 PIN PLUG This is then sent to the cell in column E My problem is that when the OLD 3 PIN PLUG is selected the transfered data in the cell reads...
  3. M

    Displaying Custom Templates

    Hi there! I noticed that when starting up Excel, along with the Blank Workbook option, there is a plethora of pre-made templates to choose from along with the option to search for more online. I was curious if it is possible to display and Pin your own custom-made templates on this screen as...
  4. T

    Placing a "Pin" in a PDF?

    I'm not sure if this is the right way of going about this, but hear me out. I have a list with a bunch of work centers in our building. When a user clicks that list, they want to be able to bring up a map and see where that work station is located. I was thinking of using coordinates (pixel...
  5. U

    Dynamic resizing of table relative to query data

    Hello, I am looking to dynamically resize a table full of formulas relative to a power query data set in a separate sheet. First, thanks you for looking and I apologize for the long post. In more detail: Every month, a large dump of data is being dropped as an excel file into a folder. It...
  6. E

    Find Copy Paste

    Hi, I've been searching for a code to handle the following, but can't seem to find the right one. That is: Find the "ERROR" string in column A of Sheet1, Copy its string value in column C (J1.G0203 for example) Paste it in col/row A2 of Sheet 2. Loop until all ERROR string values are...
  7. L

    complex split formula to merge as per description

    I have a formula which looks in column K ,L and G to merge pack size description in J , However In G only the conversion units are extracted that is L , cl with its corresponding numbers. However I having trouble when adding L litres corresponding for wines only , I have tried to add 1 litres...
  8. M

    Get Search result in excel

    Hello Friends... Is it possible to get the distance between two area according to their PIN code in excel. I use the below url to search for the distance by just providing the PIN code of area. http://alldistancebetween.com/ For Example if i have starting PIN in Column A and Destination PIN...
  9. W

    Online changing value: pinning calculated cells

    Hello I'm using a value of an external online source in excel, which changes everytime the value on that website changes. This way I can calculate my daily profit or loss (investing). The problem is that, when i'm for example 5 days later, my profits of day 1 change according to the value...
  10. C

    Cell Matching Without Using Volatile Functions

    I have a very big WS that I am trying to speed up by getting rid of volatile functions like Indirect. Occasionally the spread sheet changes which makes things even more difficult because of Indirect. Column A numbers 1-24 and repeats like hours on a clock. Column C represents a 24 hour period...
  11. A

    Sum of an IF/AND statement

    I am having a problem with my formula. I have a wrestling record book that I am trying to get points for. Example if a person won a match with a pin I want them to get 4 points. If they Lose a match they lose .5 points. I want to be able to add up points for Wins/Loses and How they won. The...
  12. R

    Pin Command Button to Cell

    Hi All, I have the following code to pin a command button to a specific cell. My question is how to modify this code to pin different command buttons to different cells. The code is written in the workbook activate module, so that when I open the workbook the buttons are in the correct places...
  13. S

    short characters and digits in a cell

    <tbody> NAYASARAK, CUTTACK, DISTRICT CUTTACK, ORISSA-753002 <tbody> BAGHTHALA, BLOCK, TAHSIL - BAWAL, DISTRICT - REWARI, PIN - 123501, HARYANA <tbody> 947,10TH 'D' ROAD, SARDARPURA, JODHPUR - 342001 <tbody> PIN 123504, NOORGARH CHOWK, HAILY MANDI, PALHAWAS ROAD, NOORGARH, i have...

Some videos you may like

This Week's Hot Topics

Top