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

  • 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