i have copied and paste text and numbers from a file into EXCEL. Now in one column i have the header and 4 lines, ie Header: Details Line 1: Email :* Line 2: Tel : *( )* Line 3: Fax :*( )* Line 4: Web address :*
I want to move Line 1 to 4 into different colums for sorting and pivot reasons.
I have an Excel sheet with several columns of data, each containing the link to a website. To the far right of this data, I have a column called "Official Source" in which I'd like to copy over any website links containing the phrase "sec.gov" (if there are any, if not than leave the cell blank).
For example, if I have the following data in my sheet:
Column A Column B Column C [URL].... [URL].... sec.gov/Ar
Than I would want the last source to move to column D -
Column A Column B Column C Column D [URL].... [URL].... sec.gov/Ar
I am trying to create a macro to do the following (Microsoft Excel 2002 SP3):
1 - Select the text from the active/selected cell (i.e. B1) 2 - Cut the text from B1 3 - Move to the cell directly above the active/selected cell (i.e. A1) 4 - Add a space to the end of whatever text is in A1 5 - Paste the contents that were cut from B1 after the text and space in A1 6 - Delete the row where the text was cut from (i.e. entire row B)
I have never written code for macro's before, only done recording, but just can't seem to get this sequence to work .
I am working on a macro and, as part of it, I would like to look at column H of my spreadshet. If the wording in any cell in column H begins with the word, "total" I would like the cell contents of the cell in column G and up one to be dropped down one. Here is an example:
Let's say that the words "total money" is found in cell H2. I would like the cell contents of cell G1 to be moved to G2, making boths cell side-by-side having text in them - G2 and H2.
Removed screen shots - Please DO NOT use actual personal information, sample data only! - Moderator
Some of the people on this list have a second name entry on the line below their first name entry. ALL of the people on the list have an Address2 on the line below their Address1.
How would I move the second name entry into the cell next to the first name entry, and then concatenate them, and then also move the Address2 entry into the cell next to Address1 (but not concatenate these)?
In a large database with a large portion of cells that contains a flag to the left of a number "<LD 2.0" what would be the quickest way to move the flag to the left of the number so that it reads "2.0 <LD". This seems like it should be simple to do. I would prefer not to have to use a second cell and formula to do the modification if that makes sense. I'd rather do a "Find and Replace" if possible.
There are basically four fields of text (date, trans. #, merchant, $ amount) all in one cell that I would like to have in 4 separate columns without having to cut-paste, cut-paste, cut-paste. Is it possible for me to break this information up quickly into 4 separtate columns? I have about 400 lines of text like this and would like to find a faster way to do it.
I have a column which contains a series of alphanumeric characters some start with the alpha characters and others end with them.
As an example ABS1234, 1234ABS, 12k34AB needs to be ABS1234, ABS1234, AB12k34. The number of alpha characters at the end will be a minimum of 2 and a maximum of 3. Is there some way that I can move the Alpha characters, at the end, so that they are always at the beginning of the string?
I have a set of data that has a store number in cell A1, the store name in B1 and then the store address in C1, C2, and C3. This pattern repeats for all ~300 stores. I am trying to get all of the store data on one row per store.
I have some macros that will look for a certain item and then move it somewhere else on the spreadsheet. However, I can't seem to get the code right to skip over the section if the text is not found. I assume it would be easiest to do it with error handling, but the attempts I've made haven't worked.
the macro will search for the text "Name" and move everything under that column elsewhere; then it will do the same for "Date." But currently, if "Name" is not found anywhere on the spreadheet, it will cause an error and ask to end or debug.
I have a text string in a cell. it is comprised of a series of numbers and text. i would like to " cut" the first part of the string starting from the first space and paste in the cell to the left. For example.
range("b11") has the following: "This is my example"
I would like to perform the following:
range ("A11") would equal "This" Range ("b11") would equal "is my example"
(note the space has been completly removed as well)
I am importing a 20 character text string (from a barcode scanner) to H2. I need to send that data to the next unused row in Column A (after insuring that no matching text currently exists in Column A-no action taken if matching data is found). I can provide a copy of the sheet, along with a description of the project.
how to cut a string from text and copy it to another cell: Example of a TEXT:..........................
This is Text in one cell - I need to cut the BOLD part. It always ( if appears ) is after statement <b>Kod Producenta</b>: and before <br/> It's not always in the same place. but always between statment above. "<b>Kod Producenta</b>: STRING_THAT_NEED_TO_BE_COPIED_TO_DIFFERENT_CELL <br/>" how can i do it with VBA macro? with cpp would be so much easier but still i need to do this in VBA...
I am working with a column which always displays the cell contents with oldest notes by date first, then the newest note last. I would like to have the contents from a cell reversed with the newest user input by date on top which will simply when reading. Here is an example of a cell. The string always starts with (MM/DD/YYYY TT:TT:TT AM, then user name).
12/20/2007 8:27:56 AM MBARNEY Approval not required for this change request. 01/25/2008 10:27:32 AM KVELDANDA Change to Category, Type, Item, Region, Site, Department fields triggered an evaluation of whether or not the Change requires approval. Approval is not required.
I am trying to select and move text from one column to another. I have roughly 1,000 cells in column A and I would like to tell Excel to select characters at certain positions and move them into the adjacent column.
I want it to look like this...
column A column B ABCDEFGHI BCI
Each cell in column A has a 9-letter sequence. I would like to move characters 2,3 and 9 into the adjacent column
I am trying to have rows moved from (Schedule) to (Complete) in the attached workbook. The criteria to have the row moved would be the user-selected "Status" list changing to "COMPLETE" in Column G.
I would like to have the row cut and deleted from Sheet4 (Schedule) once "COMPLETE" is selected from the list in Column G with rows below moving up. The row would then be inserted into Sheet2 (Complete) at the top of the list (Row 7) and rows would move down below the new entry. I would also like to have the formatting remain uniform (every other row fill)
I am in need of restructuring a spreadsheet of addresses for mailing purposes. (I tried to find something similar answered previously, but nothing seemed to work for me.)
I have attached a small example spreadsheet below, but our spreadsheets can be hundreds or thousands of rows in length.
I need a macro that will look for the "PO Box" addresses under the column headers named "ADDRESS2" and "ADDRESS3".
The PO Box addresses will need to be moved under the column header "ADDRESS1" within the same row.
It will need to overwrite the text that is already under "ADDRESS1" and delete the text from the "ADDRESS2" and "ADDRESS3" columns - UNLESS the text in 'ADDRESS2" is a PO Box AND "ADDRESS1" begins with "c/o".
If the data in "ADDRESS2" or "ADDRESS3" is anything other than a PO Box it will remain the same. As will "ADDRESS 1".
Basically if there is a PO Box it needs to be in the column named "ADDRESS1" and overwrite anything else that was there. The exception will be for PO Boxes that are in c/o someone else, the PO Box will then need to be listed in the column directly after the column that has c/o.
If the c/o exception will be too difficult the code could just highlight those scenarios and we could fix them manually. We usually do not have a lot of them, but enough that we need to be mindful of them.
The different scenarios are listed in my sample spreadsheet.Also, the code will have to use the column header names in row 1 because those headers are not always in the same column.
It's difficult to explain, the attached shows the situation better. Basically there's a picture that is somehow linked to a cell. But, you can update the picture or the cell and the other one gets updated.
1. Search an excel sheet "column" for a particular type of text and insert values based on that text (if found) in another column.
e.g I have column A1 to A10 with different types of text. I would like to search for the keyword "Risk is high" OR "Risk=High" for each cell in the column and insert a "1" if found beside it's corresponding "B" column. If not found, I would like to insert a "0".
So, if the text "Risk is high" OR "Risk=High" was only found in A6, I would like B6 to be "1". Rest of the values in the B column would be "0's", since the text was not found in any of the other cells.
I have a macro which imports data from a mainframe dump text file and performs 'Text to Columns' on the imported data so that formula in the spreadsheet can act on the data. The code works perfectly well when I use it, but if a different user logs on and performs exactly the same mainframe dump and import macro the Text to Columns action splits the raw data in a different way and the result is that the split renders the formulae useless.
I've experimented a little and for some reason it appears that the 'Field Info' parameters which are produced when the Text to Columns function is recorded in a macro differ between users even though the raw data is exactly the same.
How would one go about making a module that would tell Sheet1 that if any number in column B is greater than 1 then take the contents of the row that number is in and copy it to Sheet2? Attached is an example of the workbook.
I have 8 rows (B345:B352) that have a formula similar to this:=IF(Site1!B53>0,CONCATENATE(Site1!$B$53," Scansys 942 @ ","$",Site1!D53,".00"),""). By the way, can the formula be shortened? I tried formatting the merged cell but nothing changes. When Site1!B53=0, then there's nothing in the cell.That's how I want it. But say, row 3, Site3!$B$53 >0 how do I programatically move (copy/paste?) row 3 to row 1 (since row 1 and row 2 are blank)? In other words, Since rows 1 & 2 is blank, I don't want the two empty rows there, so I would like to move row 3 up to row1.
I have a workbook with several sheets each containing different numbers of rows. These rows contain data from clients (codes etc applying to motors). The rows have been randomly populated and I am having to move rows from somewhere in the sheet up or down so the codes are grouped according to which motor they apply to.
What I want to do is select a row and be able to run a macro that will move it where I want. The destination can be up or down and any number of rows away. Does anyone have any ideas how to do this? I was thinking that if I selected the row I wanted to move and the one I wanted to move it to then run the macro it could be moved. Its not to replace the destination row, but be inserted alongside it.
I have got a problem with moving to another cell. For example, I click A1, the active cell is A1, then I wanna move to B1. I usually just need to use the right arrow on my keyboard to move. But this time, it didn't move - instead, it moves the scroll bar.