merged

Hello Friends, Vlookup formula is not giving the desired results when some cells in the range are merged. For Example. A B PO # Contract # 2) 301675 3) 301684 21130697 4) 301687 Column B2:B4 are merged cells =vlookup(c1,a2:b4,2,0) Now when i enter the po...

Hi there, I have 10 merged cell need to be locked after it's filled with date. The 10 merged cell: E46:F46 E47:F47 E48:F48 E49:F49 G46:I46 G47:I47 G48:I48 G49:I49 J46:L46 J47:L47 The current condition of the worksheet its password protected with "123" and all the 10 merged cell above its...

Hi There I have a few pop-up calendars in my workbook. The calendars pop up fine if the cells are not merged. However on a merged cell (for example A1 and B1), the calendar does not pup up. I'm OK with that but I was just wondering if there is a way to make the calendar pop up on a merged...

Hi all, Looking to return values from multiple headers in an excel sheet. I have the following table for illustration: Ideally in 'column 8' i would like to pull the value from the merged header. The problem is there are multiple merged headers running through the sheet. For illustrative...

Hello All, I'm releasing an updated template to a team for tracking schedules and need to lock down certain fields but enable others. In column A:B I have merged cells with task names. In other columns to the right I have associated dates. 1) I'd like to be able to lock this sheet to prevent...

Hello, I have word invoice template, my problem is in VAT (%) merged cell, whenever I leave VAT (%) cell in excel blank I got this error in VAT merged cell in word !Unexpected End of Formula Thank in advance.

Hi there, I have a colleague who we have moved to Office 2016 from 2010 and now a macro enabled spreadsheet is not working as it once was. He gets an error in VBA when running a macro - the error is a Run Time 1004 and states about an issue with merged cells. I've done lots of reading and...

Hi forum, Having an issue I've never run into before. I've applied filters to my top row. Many of the cells in each column are merged. When I select a column to filter, and select the value I want filtered, it only gives me the top row instead of all the rows that the merged cell in the column...

I am working on a monthly menu planner. The dates are merged between three rows in order to allow breakfast, lunch, and dinner meal items each day. The merged cells are causing the calendar to go from Jul 29, Aug 1, Aug 4, Aug 7 (so on, skipping every three days because of the merged cells)...

Dear all, I am trying to merge 2 queries. They both have unique numbers but whenever I link the two queries, duplicate rows appear. Not after the step "Merged Queries", but after the step "Exapended [name query]" ... I am desperately looking for the cause or a solution to my problem. In 1...

Hi, I have read a lot of forums discussing merged cells and how to calculate the number of merged cells based on the criteria given, however the formula below only returns the number of merged cells for the first set of merged cells and not for the entire column. If I wanted to count the number...

Hi, On my sheet columns K:M are merged cells (only horizontally merged) The same applies to columns N:P I'm trying to give a variable column offset to cells/ranges in column K with Integer Ccol1 In this example, Ccol1 = 3 So K15 as starting point should result in N15 where I want to set a...

Hi there, I have a bit of a dilemma with a worksheet... unfortunately, it involves merged cells... (argghhh... I know) I have a merged range (AK17:BT17) which is formatted as text for user input... initially I had a problem with autofit on the height of this range, but I managed to get that...

Hi Everyone I am working on a macro where I need find the column number which contains a particular text. However the noted cell is merged with others. I prefer to not unmerge the cells. Is there a way to make the match function work with merged cells? If match is not the way to go then I...

Hello, I am trying to figure out why this code is not working. I need to find merged cells in column AX. Once these merged cells arefound I need to use the following vba formula to copy the value. What am Idoing wrong? 'Select Merged cells in column AX and add header based on...

I have text string that is produced from code that can vary from approx 250 words to 1000 words. In my sheet i have two merged cell areas. I need to detect if the text string is to big to show in the first merged area, if it is then it needs to split and the last viewable word and move the...

Good afternoon, I'm not too advanced in excel. I developed a form that other people to complete. I need to have an option for them to add a line that will automatically format the same as the line above or below it, including some cells being merged and others having drop down lists. So far...

Hello everyone, I am trying to write a code in excel that will copy the selected email body and paste it to the excel sheet. I have merged all the cells required to fit the email and created a button for the user to click and the data to be copied over. Can anyone please help.

I might be over thinking this but all of my thoughts have failed. I have created a time sheet (Schedule) that auto calculates the number of hours scheduled each day. I am trying to make the cell at the end show the weekly running total. Here is my layout: C&D1 merged = Date C&D2 merged = Day...

I'm struggling to come up with a formula to do this. Can anyone help? OLD SHEET: B9: Contact 1 B10: Contact 2 B11: Contact 3 NEW SHEET: C5:9 are merged and I need B9 to populate from the old sheet C10:14 are merged and I need B10 to populate from the old sheet C15:19 are merged and I need...