1. K

    Bowler Chart for KPI using sorted merged cell

    Hi. I know this is possible bc my intern was able to do it but now that I'm trying to replicate it....I can't seem to figure out how he did it. Before everyone asks about changing the format, etc. it is not an option. We use a "bowler" chart which tracks the plan vs actual for key metrics...
  2. J

    Making a Merged cell autofit with using wraptext

    I have an issue I'm hoping you guys can help with. Basically, I would like excel to wrap within a dynamic merged box, kind of like you would get if you were typing into a word document. Does that make sense? I know if you just use wrap text, the system automatically adjusts the height of the...
  3. I

    Conditional formatting by merged cells

    Hello, I have set conditional formatting in specific range. If is not empty then background color = green + outer borders. I sometimes use merged cells in this range and by merged cells is the borders unfortunately not complet. Is there any way how to solve it? thank you very much Miroslav
  4. A

    VBA - Do stuff based on a value in a merged cell

    Hi Thanks for visiting my post. I have a task to insert a row based on the value of a cell. However some cells are merged cells, some unmerged. I have tried code below. But it does not work with "type mismatch" error:- I do not know the exact location of the merged cell. Any expert knows how to...
  5. A

    Duplicate Data

    I am merging 2 databases and joining through using the data in the amount column, on table 1 there are a few entries that have duplicate amounts, when the query is merged the power query matches table 1 Date Amount 02/10/19 7000 02/15/19 7500 02/17/19 7000 table 2 date...
  6. J

    How can I look up the value in the next cell?

    Hi, I have a set of data with a merged header cell, laid out like this: ---------------------------Merged header cell----------------------------------- <tbody> Value 1 Value 2 </tbody> I am trying to return Value 2, using the header cell as the lookup value. I've tried using HLOOKUP, but...
  7. D

    Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    Good day to you all, I'm trying to develop a formula in Microsoft Excel. I have a range of cells on one Worksheet and I want to take that Range of Cells, remove any blank cells, and sort the range of cells into a column on a Second Sheet, same Workbook. The First Worksheet is set up as...
  8. D

    Getting Power Query to add new values to the bottom

    Hi All, I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel. so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so...
  9. D

    Copy a merged cell

    What is the vba to copy a merged cell, G7:H7?
  10. A

    IF statment MERGED Cells

    Hi, Is there a way that as a result of an IF statement that 3 cells become merged? IE: IF cell 1A> 2 merge cells 2A, 2B, 2C Else Nil Thanks Aaron
  11. R

    Multiple Title Search in Cells

    Hi everyone, I'm trying to design an expense form on Sheet 2 and I have 4 types of expenses in a drop down list in merged cells F-G17 with "categories" of Office, Executive, Meeting, Conference. What I would like to do is once they choose the "category" of their expenses, merged cells I-O17...
  12. M

    VBA to format Cells with Borders based on Column Value ( merged cells)

    Hello Everyone, I know this issue has been addressed but none of the solutions really solve my problem; hope someone can help me. I have a spreadsheet with a lot of data that i was able to manipulate with codes and the last part is to now format with borders and blank cells between to make it...
  13. B

    userform - cell or column selection/reference

    I need help with this portion of my spreadsheet and userform and no better place than here to get it. I am wanting anytime any cell is selected in a given row (range myLEDGER, actually A19:AR71), a userform pops up (1st code). I figure I need to Offset back to A somehow and then Offset back...
  14. S

    Merging text files into one file...

    Can someone help im trying to merge text files into one file... using VBA, basically all is want is a all the text files in the location of the excel file to be merged, into one file and then all other txt files to be deleted once merged.. I have tried this but it did not work... strPath =...
  15. B

    Dynamic Row Heigth

    is there a way to set a set cells/rows to change the row height based on how much is typed into that cell? If the user types too much it will make the cell height higher instead of shrinking the text. I know there is some way because I have another worksheet that does this but I do no know how...
  16. J

    Assigning Macro to Cell and Running Macro Once Entry in Cell is Complete Without Opening Macro Run Window

    Hi Everyone, I'm new to the whole VBA thing, and need to create a macro that will assign a group of merged cells as text (so you don't have to insert an apostrophe (') to mark it as text (content in the cell will likely commence with a dash (-)), auto-fit the row height of the merged cells, and...
  17. M

    Trying to notate ranges of merged cells on a worksheet

    I'm trying to get a listing of all of the cells that are merged on a worksheet. I want them listed in Column D of 'Sheet1', but I can't get the code quite right. Here's what I have so far: Dim c As Range ThisWorkbook.Sheets("Sheet1").Activate ThisWorkbook.Sheets("Sheet1").Range("D1").Select...
  18. R

    Assigning/Pasting Ranges to Merged Cells?

    Hi Folks, I have a 2 small tables of string data (5 rows x 2 cols) wherein I need to use one or the other on a spreadsheet. I thought this would be a good candidate (and feet wetter, for me :) ) for a Range Object. So far—so good. The problem then came in trying to put the object into some...
  19. S

    VBA to copy and paste text from merged cells in a WB to merged cells in another

    I know working with merged cells can be problematic. I have a workbook and I am trying to copy the text (which will change from month to month) within the merged cells and paste the text into merged cells of another workbook. Of course, they are not the same size to due presentation reasons...
  20. K

    How to create number sequence based off of calculated value?

    Hoping you know of a solution to my Excel/merge problem! I am trying to figure out a way to automate our EDDM shipment forms at work because they are currently a huge waste of time to fill out manually in the current PDF format that we have. I think I have most of it figured out, but am hung...

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