Dear All,
I am using Excel 2010 and have the problem as shown in the attached file. Input Sheet shows the Data I have at present Output Sheet is the desired result. I need a macro which should create an ‘Output’ sheet by doing the following on the Input Sheet 1) 1) Insert a Blank Column before Column A 2) Unmerge the Region Heading and insert the respective Region Name in the newly inserted Column. Region Heading will be in Bold Font. 3) Repeat Step 2 for all Regions 4) Delete the Rows which were unmerged Please note that the number of Data Rows will vary for each Region. I have shown two Regions for explanation purpose only. There will be several Regions in reality. The result is shown on the Output sheet Any help would be greatly appreciated. TIA Regards Rashid Khan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Merge Problem - Group.xlsx
Description: MS-Excel 2007 spreadsheet
