group rows

I have a spreadsheet that has multiple groups of rows that are sometimes hidden and sometimes not but ultimately change the number of pages and page breaks when printing. I was wondering if there is a way to write a macro that will keep groups of rows together so that they don't split across...

I need help please. I need to group pairs of rows in my excel (2010) spreadsheet. The first row are headings. I have multiple columns of data. The even rows have values in every column (A-H). The odd rows have a value in only one column G. In column G in the even row, is a barcode. In the odd...

Hi Friends, Basically, I am looking for a macro code which would help me to group the rows based on the cell content in the column A. I have a spreadsheet which have country names in column A and data in others columns, I want to group all the countries based on its sub areas. I have to repeat...

I like some of the table autoformatting from Excel 2007, especially the way it alternates colours on different rows, so people can follow along the rows easily. But is there an easy way to format a table so that the colour is not changed on each row, but only when the contents of a certain...

I have a spreadsheet that is an income statement for the year with each month showing separately in its own column. The budgeted figures are also shown monthly per column. On the far right, I have a total for both Actual (in column AO) and Budget (AP). I am trying to find a macro code that will...

Hi, I've trying to build a reporting system in Excel, so that a list of client names is expandable. Once you click on a Client name (Simiar to clicking a parent folder in windows) then a list of projects/jobs is displayed in the next column, and when a project/list is selected, then the...

Hello, Not sure if this is possible without VBA but can anyone think of a formula for this? What I have are states and districts and by the time I'm done with this, most of the districts will have several rows each. I want to shade every other district. What I started to do was create a...

Hi, I would like to group rows in excel into groups of 3, ex: Client ABC would be on line 3, 4 and 5. Each row would contain different information about the customer. This worksheet would be used by different people and I would like them to be able to sort the list but have (line 3,4 and 5)...

Hi, I work in the IT department at a College. We have a program called SIMS which keeps track of all the data on our students and staff. One tool it has is that it keeps track of all staff absenses and spits them out in a spreadsheet when we demand it. We then email merge this off to inform...