same cell

  1. A

    All Userform data to same cell on sheet

    I’m new to VBA/Excel Coding and I am trying to do the following… When I click on a cell on the CALENDAR sheet the userform opens automatically and I fill it out. What I want to do now is, when I click OK on the userform, I want all of the data to go into the same single cell I selected to open...
  2. A

    Macro/VBA to Copy and Paste cells in same location

    I need to make a macro/write a VBA code to select from a range of cells, say H8:AQ117, all cell values greater than 1, and then copy and paste them (paste Value only) at the same location without their formula as I want those particular cells to remain unaltered as I change the values at their...
  3. N

    Formula Needed for: FIND "YES" and Return in same cell as YES

    Hi MrExcel Community, See below for a sample of data that I need to extract information into a searchable database. All of the information is provided in both columns and rows. I'd like to create TABLE 1 into TABLE 2. What's most frustrating is identifying project type by finding the YES and...
  4. M

    Return longest string within cell

    Hello Mr.Excel, I need a way to return the longest string within a cell. (number of characters) However, it should count strings based on line breaks within the cell. For example, == This is an example of text within one cell. == The above should return the value "24" Thanks!! Mike
  5. T

    Data Input - Same Cell Across Multiple Sheets

    MrExcel Forum, I have a question I was hoping someone here could help me answer. Is there a way for me to input data into the same cell across different workbooks, similar to how you would for selecting multiple sheets and adding a value in a cell (i.e., typing 5 in selected cell A2, on sheet...
  6. F

    VLOOKUP and Data Validation in same cell

    Hello! I have a data validation list in cell A2 with four options. They correspond with one of four responses and are presented with a VLOOKUP function in cell B2. Although choosing one of the four options in cell A2 provide a "preferred" VLOOKUP response in cell B2, this response is not...
  7. P

    Formula to add a percentage to the same cell.

    Greetings, I have a question. So I have this excel file with a row with many prices, and I'm asked to add each cell in that row an additional 3% of its original value. I was thinking in adding one row, so the previous row would be named "Original prices" (or something like that) and the...
  8. P

    How to use the cell selected by an inputbox and use it to loop through all files/workbooks

    Hello, I am attempting to figure out how to prompt the user to type in the cell label he/she wants from an inputbox and then automatically use that same cell address in all the files I want to loop through. I want to prompt the user only once, and not every time the code loops through each...
  9. P

    Look Up Same Cell Number from Different Worksheets

    I have file that has a daily report on a different worksheet. I'm trying to create a summary report for all the worksheets. How do I create a formula to lookup values on the same cell number but on different worksheets? I don't want to edit each formula to change the worksheet name since it...
  10. M

    How to create a workbook with presaved macros

    Hi All, I am creating a VBA application, I'm faced with a problem that is-- When a ever i create a new workbook, i am unable to get macros with which it has been created.. Plz provide me the solution... Thanks In Advance :)
  11. P

    How to use LOWER and SUBSTITUTE in the same cell?

    Hi all, I'm trying to make this: "Sly Fox" into this "sly-fox" using lower and substitute in one cell however I can only get one to work. Can someone help me with this? Thanks

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...