I need to combine or merge text from cells in 20 rows of data into a format able to be printed. This is evaluation data for a class of 20 students, where each row is one students response to the evaluation, with the last cell in the row containing their comments (text data that may be blank, or up to several sentences in length). Here's what I'm trying to do:
Combine all 20 cells into one cell that can be printed (with word-wrap turned on).
Add a blank line between each comment.
Disregard any blank cells so extra blank lines are not added.
Is it possible to write a macro whereby the data in numerous cells in a row, say A1:K1 are copied into one cell, L1 then the cells from the next row, A2:K2are copied into the same cell, L1 but on the line below in the cell. I know the above doesn't make much sense so i've attached an example.
I have a data array of 7 col and 256 rows. I want to focus only on the first 2 columns though. Here is what is going on. In the first column I have numbers from 1-256, these numbers are merged to the appropriate size to accommodate the data in column 2. However, the data in column 2 is not merged, it consists of 1,2, or 3 lines of text. Excel deletes the text in the rows below 1 if I try to merge, excel does not allow multiple row merge selections. What I am looking for is a formula that looks at column 1, finds how many rows are being merged in column 1, then looks at column 2 and identifies the number of rows needed for merging and displays that text in only one row. Basically, it's a formula that merges multiple rows of text in col 2 depending on the number of merged rows in col 1.
No.Customer/Operator 1Fairbanks Morse / Beloit, WI 2H+H Umwelttechnik /
is there a formula or macro for merging identical text cells in a column?
I am looking at data relating to familes with a row for each family meber therefore the address cells for each family are identical. I would like to merge these cells for ease of reference when printing the data to be used as handouts for staff attending the households.
From a supplier I will get a spreadsheet including the the following Information which I need to convert into an url including trailing slash (/) for an online store.
Column A = Value of Main Cartegory (e.g. Holidays) Column B = Value of Subcategory_1 (e.g. Christmas Decor) Column C = Value of Subcategory_2 (e.g. Candle Holders)
Those raw data are without any trailing slashes. Now I want to create a column e.g. Column D (product_url) which should be a summary of column A thru C but if there is only a Value for Main Category there should be no trailing slash, if there is a Value for Main Category and a Value for Subcategory_1: no trailing slash after Subcategory_1 but trailing slash between Main Category and Subcategory_1.
The result should look like this: Holidays (Main category) Holidays/Christmas Decor (Main category & Subcategory_1) Holidays/Christmas Decor/Candleholders (Main category & Subcategory_1 & Subcategory_2)
Is it possible to create something like that in Excel at all since all values will only be text and the trailing slash is actually functional for Excel calculations but in this case it would have to be treated as "text".
So what I want to do is add the numbers up so I can get one value. For example, 4RWHB I want to add them all up so that it totals 68 still shows the code and description but then only shows 68 4RWHB 4 Row Wooden Handle Welders Brush and not the same line repeated. I want to condense all the information down so where there is same model numbers I can add it up and it doesn't give me multiples but summarises it down into one line per model number.
I want to create a string of 0's and 1's in the same cell in excel.
I used the function =randbetween(0,1) to generate 1's and 0's. Just wondered if there is a way to repeat this multiple times in same cell so it looks like 1 0 1 0 0 1 etc... as an example. Or a way to merge cells?
I have a series of duplicate workbooks to allow for distribution to multiple users. The workbooks have a userform which allows the user to save records into a worksheet. I would like to have a standalone workbook which is a merge of all of the worksheets.
Since data will be contiuosly entered, I want the master workbook to have a "constant" link and alway but current without need to run anything.
employee paymethod earningcode earningtype rate hours amount jane doe H CR R 5.00 80 400.00 jane doe H CO O 7.50 2 15.00 jane doe H HL R 5.00 8 40.00 jane doe H SE R 10.00 10 100.00 john smith H CR R 6.00 10 60.00 ...
I need to have
jane doe CR 5.00 80 CO 7.5 15.00 HL 5.00 8 SE 10.00 100.00
I will have multiple employees. Not all employees will have all 4 earning codes (some will only have one, some will have two, and some will have three).
I have a task to complete that requires me to extract worksheets from hundreds of workbooks and consolidate them into one "master" workbook. Out of the hundreds of workbooks, there is only one worksheet that I need to extract from each. The worksheet's name is "CostData". Once I have all the worksheets in one workbook, I will have to create buttons that will be able generate reports and charts based off the data in the worksheets. This will assist in determining cost comparisons, trends, and predictions. I am sure something like this has been done before, so can someone please help me out! Is there any code out there that can do this?
How can I merge into a single cell from a range of selected cells that contain text. If the range of cells do have empty cells it should be smart enough to skip over or not to create an additional space. Any idea how can this be done? Macro or formula?
I will have about 100 files to merge together that are in one directory. Is it possible to merge all workSHEETS named "Bob" from each workBOOK and end up with just one master file?
I found this code on this web site (no proper reference!). It doesn't work for me. Yes, I changed the directory and it still didn't work. I will have 12 columns (A:L) and differing # of rows in each "Bob" worksheet.
VB: Sub g_CombineMultWB_AllXLSFiles() ' This Will combine all EMALL XLS files located in the ' S:DMSMSPOMSMaster POMS NIIN DataMaster EMALL Data FilesEMALL Excel Folder ' into a single worksheet in a newly created (or previously existing) workbook
I am trying to mailmerge a spreadsheet relating to invoices. there are multiple rows for each company, however each row is a unique Invoice Number.
Instead of email mail merging normally, I want just one mail merge made for each company, where it lists the invoices there, rather than a whole new document per row. Otherwise I'd send one company 50 emails!
I have attached an example spreadhseet - and I have attached a screenshot of the word document Im working on.
Dont ask me where I got that code at the top of the word document - ive copied and pasted from somewhere - it might as well be written in italian. Im trying to match the mergefields with what I think it's trying to denote. Yet, I cant make an If then else mergefield?
Is it possible to do this sort of mail merge, then use the email column to designate where to send the finished merged product?
I have a workbook with multiple sheets (21 sheets) in it. The header on each sheet begins at row B5. The actual data starts from row B6. The number of rows in each sheet varies and the last row contains the total for all columns that has numbers. I wish to have one sheet that combines data from all the 21 sheets. But;
1) The header should be repeated only once 2) Only the rows that has data should be included, blank rows should be ignored 3) I do not need the last row i.e. total to be considered while merging the sheets
I've given a snapshot of the data below. The first column contains the row number just for reference.
B5 Name Address Telephone Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total Other Members B6 Tony PQR Complex Road 1 12345678
I'm trying to take a single worksheet from a workbook and merge them all into one workbook. In that master workbook I'm looking to have each of the worksheets on different tabs and the tab names as the original workbook name.
So if I have Workbook1, Workbook2, Workbook3, Workbook4 in a folder. I want to open a new spreadsheet, run this macro, select the folder with the Workbooks in, and have it take the range selected from the worksheet 'other' from each of the workbooks and generate a 'master' Spreasheet where each tab would be called Workbook1, Workbook2, Workbook3, Workbook4 and the contents would be from the 'other' tab
I found some of Ron de Bruin's code online which I've tried to customise.
Currently this takes a range from the tab specified, puts it into an array and then pastes it all into different columns on one worksheet. change this so that it creates a new worksheet for each original workbook, and names it after that workbook.