merged

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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