same cell

  1. Z

    Mutiple Math Operations in the Same Cell

    Apologies if this has been answered (a post from 2020 didn't solve it and I can't find anything else).... I want to create a formula that adds two cells THEN divides the result by a third cell. eg. (B6+B7)/G23 Alternatively, I'd like to add multiple cells in the denominator as well (like the...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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 :)
  12. 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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top