multiple rows

I want to write a macro that will merge every three rows at a time and center the data in an Excel table. This should be done for three columns, but the macro can just be run separately for each column. The tables can vary in length but could consist of over 100 rows. They would typically...

Hi, I have a Combined INDEX&MATCH Formula that works, but when I change just one criteria bit to find a different Department it stops working, why is that? My Data set is the below: <TABLE style="WIDTH: 536pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=712 border=0...

I have several rows of data that contains data in the following format. 123, abc, 456, def, 789, What I would like to do is Concatenate them all together to get the result 123,abc,456,def,789, I have a total of 100 rows like this that I am trying to concatenate. I have tried all sorts of...

I have over 40,000 rows of information that i need to be trimmed down. Is there a easy way to delete every OTHER row of information? I need help fast.

I want to select entire rows of selected multiple cells. The cells are not standard (exp. g66, f45, g74 etc. or d22,e54,d64 ect) So, I am selecting multiple cells and i want to able to copy the entire row of those selected cells and paste on sheet2 and delete from sheet1.

Hi, I am trying to insert multiple rows into an Excel cell. I don't want to always rely on 'Alignment', 'Wrap text', and use 'alt + enter' (and have done so successfully since Excel 95 - at work). However, I haven't been able to use alt+enter for some time now on my home computer. I have had...

Hi all. I'm a newbie here. I have this worksheet. What I have here is one activity ID with multiple information on BOQ and its related data. What I would like to have is just Columns A-J and move the required information in columns K-AS to H-J. The result of this will give me multiple rows of...

Hi, I've spent days trying to resolve this and would appreciate any help. Have large data range up to 20,000 rows and need to find and delete duplicate headings within the rows (heading covers 9 rows separately). My code successfully finds and deletes the first row, but not the 8 subsequent...