I have a spreadsheet of barcodes 114,618 rows long. I have a program that requires me to enter in each and every barcode in a certain format. This is the format that it requires me to place the barcodes into.
Now I have a Macro to add a comma to the end of these barcodes. That part was a breeze, however, I have hit a brick wall when it comes to placing them into an ongoing sentence type format, that my program needs. I have found several ways to combine and merge and "justify" the content, however these typically only cover small amounts of content, and doesn't even come close to hitting anything over 100,000. I don't know if maybe I need to be using another program in tandem with Excel.
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 some text in a cell, which is longer than the width that I am going to make that cell. When I don't wrap the text, it cuts it off at the end of the cell.
Since each column represents a day in a calendar, it would be incorrect to merge the two cells, but I don't want the text hidden, since I need to print the final product.
It is non-numeric text, and i've pasted --> values to remove formula issues.
- In column A, I have list of items that take up 700 cells (i.e. the text is in cells A1, A2... A700).
- I have applied conditional formatting to these 700 cells, so some of them are now highlight YELLOW based on a criteria (i.e. cells A3, A14, A422, A654 are yellow)
- I want to create a list of these yellow cells in column B.
This code is taking way too long to display the actions that it executes. It didn’t used to be that way. I was wondering if anyone knows why this may be. The Excel file is large – over 8 MB.
Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "N:N" Dim Cmnt On Error Goto ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Row > 3 Then If Me.Cells(.Row, "N").Value = "" Or Me.Cells(.Row, "N").Value = "O" Or Me.Cells(.Row, "N").Value = "H" Then Me.Cells(.Row, "A").Resize(, 26).Interior.ColorIndex = 0 End If If Me.Cells(.Row, "N").Value = "C" And Me.Cells(.Row, "O").Value = "DR" Then Me.Cells(.Row, "A").Resize(, 26).Interior.ColorIndex = 39 End If If Me.Cells(.Row, "N").Value = "C" And Me.Cells(.Row, "O").Value = "HJB" Then Me.Cells(.Row, "A").Resize(, 26).Interior.ColorIndex = 6 End If.....................................
I need assistance with a formula two merge data of two cells together. For instance I have a column 'first name' and 'last name' and I want to create a column of just 'name' and concatinate the data eg: John Smith. I have roughly 175 cells to do this for.
Merging cells where the row is a variable. The code has two loops that consolidate date from two other sheets, it works fine but as you can see it puts the data into columns A,B and C,D respectively. My goal is to combine both into the A,B columns, which I can do very easily. My problem is that between the loops, marked by "HERE" i want to skip a line, merge cells A and B on whatever row that maybe and set an header.
how would i run a macro to merge duplicate cells in a column
For example, i have lots of data in columns A, B and C
however some of the data in columns A and B is the same. Column C data never changes. so to make it easier to read, i would like to merge these cells (which are the same) together?
-ColumnA- Cat Cat Cat Dog Dog Dog Dog Mouse Mouse Mouse Mouse Mouse
would become.... (with all the other data the same)
-ColumnA- Cat
Dog
Mouse
I dont want to lose any of the rows, as the data in column C is always different. I just want to merge the similar ones, so its easier to read.
Its a bit like this, but i cant even come close to getting this to work: [url]
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.
How do i separate example: #EM/13/10000749#JTDEl_1234#abc-NORTH#1##No Traffic Data into separate cells like 0749 to A1 , JTDEl_1234 to A2 , abc-NORTH to A4 , 1 to A7 , No Traffic Data to A5
And then continued with another text of the same standard to the next row by just copying from "Notepad" and pasting it in excel.
All the text is following the same standard.
Example : #EM/13/10000749#JTDEl_1234#abc-NORTH#1##No Traffic Data #EM/14/10000730#JTDEl_1256#abc-SOUTH#3##No Connection #EM/09/10001683#JTDEF_5674#abc-EAST#2##Low Data
how to add alternating cells when all are numbers, e.g. B8 to KW8 are all numbers and I want to add B8, D8, F8, etc. until KV8 and then separately add C8, E8, G8, etc until KW8. Is there a more efficient way to do this than =sum(b8,D8, etc)? I also need to do the same with =counta(b8, d8, etc).
I want to merge some cells using a criteria. To be more specific, let's speak on the file attached.
Beginning with the P5 cell I want to merge to the right groups of 4 cells for each name from the column J. Therefore the first group of merged cells will be P5:S5, the next group will be T5:W5 and so on until reaches 11 groups of 4 cells. The last group will be BD5:BG5.
I tried a script like this but it says that there is a syntax error on the "Else" instruction:
I am programming VBA for Excel and I have a problem with automatic popup messages. I would like to answer Excel's request "Selection contains more than one value. If cells are merged, only the first entry will remain" with OK. The cells are sorted, so they contain the same value, hence I want to merge them. Of course I could work around and delete every entry except for the first before merging, but I would like to know, how to answer this popup automatically, so that the user does not get to see it.
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.
I am trying to merge two cells that have the exact same content in each cell. Everytime I do this, I get a pop-up warning that Im trying to merge cells with content in them and that only the upper-left content will remain. This is exactly what I want, without that pop-up, as I have to do this for multiple columns at a time.
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.
Cell M contains the number 001-1234 Cell N contains the number 1234567 (I have formatted the cell to appear with a dash at the beginning -1234567 Cell O contains the number 891 (I have formatted the cell to appear with a dash at the beginning -891)
I want to combine the three cells and have the number look like this 001-1234-1234567-891
Is there a formula that will do this
I have tried the Concatenate to combine the cells but it just combines the numbers and won't let me format the number as I want it.
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".