Summary: Concatenate (combine) Header Row with Variable Number of Detail Rows I need help writing an Excel VBA routine. My input worksheet consists of rows, wi...
Summary: I make frequent Excel spreadsheets that are more than one page when printed. I would like to know if there is a way to make the header row print at th...
Summary: Hi, What I would do is to create 'complete' rows of data. The layout you have is fairly typical with headings and subheadings, which are not shown on ...
Summary: After Hours Support Roster THE PROBLEM I have to prepare a weekly after hours support roster with the following criteria: The roster changes each Wedn...
Summary: i tried already and it gives me #ref!. i've checked the value in the formula and it is all correct. i've used concatenate and put it in at the same ro...
Summary: I have a spreadsheet with over 2000 lines of data. Column C has my data of interest. Several lines of the data are the same, then it changes to a new ...
Summary: For a macro to keep track of where it is while deleting rows, it has to delete them from the bottom up. Before it can do that, it has to find the bott...
Summary: From reading your post, you want your whole sheet to be sorted according to the column headed COE, correct? If so try this: First create your Macro: O...
Summary: Without dissecting your code, I'm going to ask a question: Have you used F8 and the Watch Window to single step through the code to see what it is doi...
Summary: Hi I'm creating a workbook to generate invoices, with an "input" worksheet for people to enter data and an "invoice" worksheet which will be protecte...
Summary: Thanks Mr. Stuart, but the problem was not solved. It is not possible to eliminate EUR with find and replace on the received contents of the cells (no...
Summary: Hi! This is my first post so I hope you poeple can help me. In work (a camera firm), I have been asked to update their list of replacement cameras whi...
Summary: He means where you see sheet1, sheet2, sheet3, sheet4 down the bottom of the screen: He's asking if you can have one row with sheet1, sheet2; then und...
Summary: Hello, I have 87 different SPECIES listed in column A1:A87. I have 87 PRICES in column B1:B87 that correspond to the species on the same rows in Colum...
Summary: Excel is seeing the colon (:) and formatting the cell as Time. For the example page you gave, the fix is easy: Highlight the problem cells and format ...
Summary: Good day, i have two excel sheets, one with information in rows and each row has an id number (1,2,...,300) and the other sheet has the same structur...
Summary: If you really trying to simply delete every other row in a range, try this "generic" method: 1 - In a blank column in your spreadsheet, enter A in the...
Summary: this is a bit tricky! Got it to work using the DMIN function. Note this formula requires you to have headings at the top, and you'll need to hide some...
Summary: Hello, I've been breaking my head over the following: I have a matrix of 50 by 20 cells. The row header of the cells is contains figures from 1 throug...
Summary: I need to do some tricky transposing in Excel. I have 4 columns with many rows of data that looks something like this: DATE NAME ITEM COST 3/1/09 J...
Summary: Hi I have an excel spreadsheet with two columns of data. The first column is all descriptors. The second column is data that pertains to the descri...
Summary: I have a report with the column A as the client ID numbers all the way down the column different numbers in each row, and my boss gave me a list of cl...
Summary: I am trying to do a macro with multiple actions. One thing that I need it to do is to go to the last line containing data in a spreadsheet. When I rec...
Summary: If I wanted to delete rows that contained #N/A in Column A, and I wasn't concerned about any other error showing up in that cell, I'd use something li...
Summary: Hi I have two separate spreadsheets. One is a calendar for my department in a ships agency company, which is where the data must go, and the other is ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
