I have just generated a report of current customer numbers for our company. Unfortunately it reports it as "162 (162)". No idea why the program does it like that because it now makes using VLOOKUP very difficult.
What I want to do is copy the "162" part of the cell and paste it into the adjacent cell to make it easier to manipulate the worksheet. All of the customer numbers are in column D if that makes a difference.
Is it possible to preserve original text formatting when copying and pasting only part of a cell. Like, for example, a cell may contain ten words one of which is in red and underlined. How do you copy that one word and paste it in another cell so that it remains in red and underlined?
View 4 Replies View RelatedI have a macro that copies all my sheets onto a new sheet called combine. It is pasting onto the combine sheet starting on cell A2 instead of cell A1. Following is my macro.
Sub Combine()
Dim J As Integer
Sheets(1).Select
Worksheets.Add
Sheets(1).Name = "Combined"
On Error Resume Next
For J = 2 To Sheets.Count
Sheets(J).Activate
Range("A1").Select
Selection.CurrentRegion.Select
Selection.Copy Destination:=Sheets("Combined").Cells(Rows.Count, 1).End(xlUp)(2)
Next
End Sub
Say I copy "My name is John Doe"
In Cell B2 or D9 or whatever, I want to insert a Comment with it being "My name is John Doe"
How do I make Paste work in Comments?
How to copy part of a cell to a new cell when there are no spaces or specific features to use in the formula. My cell contains a data and time as such: 2013-10-22T14:05:34Z
My hope is to keep the data 2013-10-22 in one column and transfer the 14:05:34 to a new column...if the 'T' and 'Z'
I have a lot of titles like "A Company - Strategy A", "A Company - Strategy B" and what I am hoping to do is strip out the part after the hyphen to the cell directly above. This is the case across about 200 columns, I'd imagine this is pretty easy?
The attached spreadsheet makes it very clear.
How to copy and paste conditional formatting with our changing the cell values. My first row of data starts in row 4 and here is what I have in D4
If D4 is less than or equal to AA4, AW4, BS4, CO4 then it will highlight D4
Now I want to copy that format and paste it for all rows in column D. The problem I'm having though is when I paste the formula it doesn't change to match the row I'm on. For example, when I paste it in D5 this is what I get
If D5 is less than or equal to AA4, AW4, BS4, CO4 then it will highlight D5
How do I paste it so that it will update to show AA5, AW5, BS5, and CO5. I want to be able to do this for 500 rows.
I want to copy the current region on sheet 3 and paste that into sheet2 starting with cell E4. But I don't want to actually use the copy method. I believe there is a way to do this. I was thinking the following:
[Code] ......
The idea I had was to simply state that cell E4 would be assigned the value of CurrentRegion on sheet 3. Is there a way to bypass the copy method?
If not, how to copy, then paste?
Is it possible to lock in the formatting that would require 12 digits even if someone was copying and pasting to the cell?
We are looking to make our users add information into cells in the format 0-00000-00000-0. They are often copy and pasting, thus overwritting the custom format we have in those cells.
I've looked at validation, but custom only works for a formula.
I have the following code which copies and pastes from one row to another
View 3 Replies View RelatedI've got cells which change after I use Solver to do simulations, These cells after the calculation is run I'd lke to paste into a seperate sheet and row for example (in preparating of charting them for example)..
I would like to paste it as folllows for example... .. but problem is, let's say the below list are in column A of the new sheet, than column B would be the first output of the calculation in the other sheet, column C would be the second output from the calculation in the other sheet. and so on..
I don't know the first thing on scripting, but I'd like to click on button where the calculations are made which when clicked on ,will paste to the other sheet in this sort of manner below.
Each calculation will use another column.. so the script must recognise there is other columns to the left already filled, ie. B, C, D, E F, coresponding to the results of calculations already performed.
Gross income
Expenses
Net Tax
I have a sheet where i have many differently named areas (like state1_1 and state1_2) When I doubleclick on a cell then a macro should run with following criteria: 1) Macro will run if the doubleclicked cell is part of any range in the list. Here I mean that names of ranges which belong to that list start with word state (like state1_1 and state1_2). No other ranges should not be in that list. If the cell is not in the range that is part of the list, then nothing should happen.
View 2 Replies View RelatedI have a graph, that I would like to be able to copy from one sheet and paste into another, is there away of doing this without dropping the data i.e. every time I copy and paste the graph clears, I don't want to copy the spreadsheet data as well as the graph is purely for a visual
View 3 Replies View RelatedI have attached the file. The row being copied is row "X" for both buttons. I have 2 buttons in the same worksheet to copy a row and insert the copied row below it. I have this macro running for 2 different rows in the worksheet, assigned to the respective 2 buttons. See my code below.
View 4 Replies View RelatedI have a folder with files in it. I want to copy the file names and past them into my Excel spreadsheet. This seems like it should be a simple task.
View 6 Replies View RelatedI am creating a macro for a monthly report of inventory. When I filter out items and the copy and paste them to another sheet, how do I tell the macro to paste it in the next available cell rather than say A20? Because the report has a different number of items and filter results from month to month.
View 3 Replies View RelatedI have a range of cells I want to copy which has some textboxes and check boxes in it. When I do a copy/insert cells in vba it only copies the cells and their values but not any of the boxes.
.Range(.Cells(Origin.Row + 1, Origin.Column), .Cells(Origin.Row + 12, Origin.Column + 10)).EntireRow.Copy
.Range(.Cells(Ind.Row, 3), .Cells(Ind.Row, 3)).EntireRow.Insert Shift:=xlDown
I have a large data which is placed in single cell and I want to copy it into a template which is merged cells any I'm stucked. My data is very large and I can't unmerged the destination data(they are merged vertically). So I wonder is there a way to copy a single cell in a merge cell.
View 1 Replies View RelatedI'm trying to write a macro that looks in cell A1:VGH1 for the text "Name:" within the row, then copy that cell and other following cells and paste into a new row. This macro can loop through the row until all instances of the text "Name:" and the following cells are on their own row.
What I have currently.
Name:xxx From:xxx Name:xxx To:xxx From:xxx Name:xxx: To:xxx
The result
Name:xxx From:xxxx
Name:xxx To:xxx From:xxxx
Name:xxx To:xxx
Why my code is not working. When I choose a single column it works. Once I select more than one column it doesn't work. It something to do with my "column1:column2" reference.
View 2 Replies View RelatedI have the following code (which works fine when the sheet isn't hidden)
Code:
FinalRow2 = TtlRev.Cells(Rows.Count, 1).End(xlUp).Row
TtlRev.Range("AM6:AO6").Copy
TtlRev.Range(Cells(6, 39), Cells(FinalRow2, 41)).Select
ActiveSheet.Paste
However, I need to hide the sheet, but it doesn't work because you can't use .select on a hidden sheet I believe. Any way of doing this to a hidden sheet?
I am having trouble with a project for school. The instructions are: (In Worksheet 1) Type Your Name. Now, begin recording a Macro. Copy and Paste your name from Worksheet 1 to Worksheet 2. Fill in the background and edit the font. End.
Here is an example of the coding.
ActiveCell.Range("A1:E1").Select
Selection.Copy
ActiveSheet.Paste
Application.CutCopyMode = False
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
[Code] .....
Now, according to the instructions I should be able to run the Macro in any worksheet....but anytime I run the Macro in any other worksheet I just get a yellow block without my name there.
Do we get the option in excel to copy from different locations (just copy a part from say Sheet A, Sheet B and some other excel file) and then pasting all at once in some other file?
View 2 Replies View Relatedi have a huge table which i've filtered for a value in a column. my data has been reduced from 20000 to 100.
how can i copy and paste ONLY the values for those 100 rows? (4 columns and 100 rows)
everytime i do it, it copies all 20k rows!
In my very crude code below....I would like to speed up the coding so by extracting data from some 800 CLOSED workbooks and pasting the data from Non-contiquous cells in an active workbook on one sheet. Can't seem to ge the = Excelmacro4 closed workbooks method to work so I went with opening each workbook, extracting data and then closing each workbook...way too slow.
Question 2. As the loop progresses...I would like to concatenate the text strings copied from the Source books Ranges G4 and G5 as they are pasted into a single cell in the destination workbook. Can't figure out how to either concatenate or xlpaste special in the coding.
Question 3. IF a user has a one of the workbooks OPEN, how do I copy that data as well other than On Error Resume Next?
Dim wbOpen As Workbook
Dim wbDest As Workbook
Dim WS As Worksheet
Dim i As Long
Sub GetdaData()
Application.ScreenUpdating = False
Application.EnableEvents = False
I have multiple customers in a list that I would like to create individaul tabs for each, with customer name and store #, and at the same time utilizing my sales sheet template for all customers. Is there a way to do this without copying and pasting one by one.
View 9 Replies View RelatedI have a main worksheet with several categories in column A. I would like to set up an IF statement VBA macro, where by if cell "A2" = XYZ, then copy entire row 2 to worksheet XYZ; if cell "A3" = ABC, then copy entire row 3 to worksheet ABC, etc.
View 4 Replies View RelatedI just need a code that will copy items in a row from column A:F...
View 5 Replies View Relatedi have a column of data part number part text e.g 7w1,8b1 in the next column i want to write a function that will look at the other and dependant on whats in it place a word e.g. for 8b1 i need it to look at the "b" and enter beauvale if theres no "b" but a "w" enter wollaton, i have tried an if function and used "*b*" but it doesnt seem to like wildcards ....
View 9 Replies View RelatedI have some cells with text entered in column A.
These cells contain a time reference either in '09:30 - 16:30' format or just an 'AM/PM' format.
What I need to do is to populate column B with the part of the string that comes AFTER the times in the text (either in hh:mm format or AM/PM format)
Example
336 Data 2012 Classroom Induction 2012/08/28 09:30 - 16:30 data about this ------> data about this
336 Information about this 2013/04/04 09:00 - 13:00 Information 2 ------> Information 2
336 info CHS Suffolk 2013/05/07 PM DRC, BSE ------> DRC, BSE
364 information 2013/02/12 AM DRC, BSE ------> DRC, BSE
I cannot get this to work and cannot use Text To column as there is no character I can use to split it.