Copy Selected Lines

Feb 10, 2006

I have two sheets.
sheet 1 has a list of invoices.
on sheet 2 I just want to list certain invoices.

so sheet 1 may be like this:

001 rmb $25.00 1356
002 ght $35.02 4568
003 ght $45.23 5689
004 rmb $12.25 4568
005 bnj $1.25 4568
006 sdr $12.54 4568
007 rmb $65.25 4568
009 bnj $56.54 4568


On sheet 2 I need it to pull out all the rmb lines.

001 rmb $25.00 1356
004 rmb $12.25 4568
007 rmb $65.25 4568

I could make sheet 2 in to a list and sort it that way. but what I
need to do is pull the information into sheet 2, it's no good being
able to sort it on sheet 1.

View 9 Replies


ADVERTISEMENT

Copy Lines Depending On Agent Selected And Date Range

Feb 3, 2010

I am having issues with this Macro since I have to run it on computers only supporting Excel 2003 and computers with Excel 2007. The Macro in use is as follows:
--------------------------------------------------------------------------------------------------------------------------------

View 9 Replies View Related

Formula To Copy Lines Depending On Date Range And Agent Selected

Jan 30, 2010

What I would like to do with the information that I have put together on a different workbook is to reference an Agent (column A), and a time range (Date is in column D) and then copy the row from A to I for each occurrence during that range of dates so we can see how many and what errors have occurred during any range of dates selected. (I will have different people inputting errors at different times so the dates will not be sorted unless they have to be). I want to be able to select different agents/date ranges to be able to get a glance of how that particular agent did during this time frame.

Here is an example of the work sheet where the data is originaly.

[Removed]

Here is an example (in a different workbook) of what the sheet should look like if I was searching errors for Albert Ozier between 1/25/2010 and 1/28/2010.

[Removed]

View 9 Replies View Related

How To Convert Selected Multiple Lines Of VBA Code Into Comment Line

Jan 29, 2014

Adding ' in the beginning of a line converts the rest into comment line. I wonder if there is an easy way to convert a huge area into comment line to try something on code. I couldn't find such an option in the menu.

View 2 Replies View Related

Excel 2013 :: Merging Selected Lines In Worksheet To One Line - Removing Dupes?

Aug 12, 2014

I merged about 15 adresslists from media contacts to one excel list. Each list had a name i.e. music, health, theater, etc. and the same logic in colums. I added a few columns and have 1 large list now.

As some journalists write about music & health & theater, architecture, etc. they are listed up to 10 times in the new list now. But the "genres" from the original list i.e. music, health, theater, etc. are in different columns. Some of the lines have empty fields (i.e. no address or mail)

All I want to do is have one line with all the information of all 10 lines in it, merged, dupes removed:

company - firstname - lastname - Adress - Mail, etc. : genre: music - health - theater:
example.xlsx

I atteched an example of the full list and the result i want

View 9 Replies View Related

VBA - Displaying Values In Multiple Lines If Multiple Checkbox's Are Selected

Sep 10, 2012

In my userform I have a list of check box's that can be selected. Currently if more than one is selected, they will appear in the spread sheet in the same line one after another with a space between them. How do I make it so they either appear with a comma appearing after each, so the next value appears on the next line below or most perferably the cell turning to a drop down list with the values?

Current code

VB:
If CheckBox1.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox1.Caption
If CheckBox2.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox2.Caption
If CheckBox3.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox3.Caption
If CheckBox4.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox4.Caption
If CheckBox5.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox5.Caption
If CheckBox6.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox6.Caption

Spreadsheet current cell appearence if all 6 are selected ' Chinnook EH101 Lynx Puma Sea King Fixed Wing'

Required appearence:
Chinnook
EH101
Lynx
Puma
Sea King
Fixed Wing

View 1 Replies View Related

Copy Macro With Many Lines

May 26, 2009

I'm having an excel sheet with addresses. I need to copy some lines of the first sheet to the other sheet. Between the lines I want to copy there are 7 lines which shouldn't be copied.

I created the following macro which does the job: ...

View 11 Replies View Related

Copy Selected Rows & Insert As Many Times As Rows Selected

Feb 6, 2008

The following code inserts a row below the selected row, and copies the formula of the row above into it.

Dim Rw As Integer
Rw = ActiveCell.Row
Selection.Insert Shift:=xlDown
Rows("" & Rw - 1 & ":" & Rw - 1 & "").Copy
Rows("" & Rw & ":" & Rw & "").Paste

However, I need to alter this to work for inserting more than one row at a time. ie. the user selects 'x' number of rows and 'x' rows are inserted below (in the same way 'Insert Row' works in Excel) and the row above the selection is copied down.

View 2 Replies View Related

Macro To Insert Lines And Then Copy And Paste Data?

Aug 23, 2012

I'm looking for a way to write a macro to insert 5 lines at the end of the data in column A. Then I want to copy a range into the newly inserted lines. I would press a button anytime I need this to occur.

Current last line of data A39

Need to insert 5 rows after A39

Then copy range BA30:CB34 into the newly inserted rows.

View 4 Replies View Related

Copy Data On New Lines From A Source Sheet Based On Criteria

Oct 2, 2006

I have a source sheet which contains data. Within this data there is a column (column 3) called Name and I would like to take the data from this sheet and paste it onto a new sheet but in grouped format. So take all instances where it finds criteria 1, then 2 and so on and just paste it on a new line each time it finds a criteria. So far I have the following code to search

Sub loopy()
Dim rngTemp As Range ' the range variable declaration
Dim intCounter As Integer 'counter as integer
' the following loop goes through all the cells in column a up until the last used cell in the column
For Each rngTemp In Range("a1", Range("a" & Rows.Count).End(xlUp))
'increment the counter if the cell has value fridge
If rngTemp = "Fridge" Then intCounter = intCounter + 1
Next rngTemp
MsgBox "There were " & intCounter & " cells equal to Fridge"
End Sub

View 2 Replies View Related

Find Summary Row On Multiple Lines - Copy Entire Row And Paste To New Sheet

Sep 21, 2013

I have a file that has simple stats for multiple days. At the end of each day is a "Summary" line. I can't figure out how to find the lines that have the word Summary in them and copy all the values in that line to another sheet. I've made a mock up of my data. I have minimal experience with Macros, but am learning quickly.

Period Start
Calls
AHT
Sch
Net
SL Calc

12:00 AM
15
299
5.5
1.24
93.33

[Code] .....

View 4 Replies View Related

Copy Selected Sheets

Dec 18, 2008

I use the command ActiveWindow.SelectedSheets.Copy to copy selected sheets into a new workbook. As a result of this line is a new workbook created and a the selected sheets are pasted into the new workbook. Is it possible to paste only values by using a single line like this?

View 2 Replies View Related

Copy Method (copy From The Selected Cell And Paste One Cell Below(next Row) In Same Column)

Oct 23, 2009

what is wrong in this code, it does not paste.

HTML Range("A65536").End(xlUp).Offset(0, 0).Select
ActiveCell.Offset(-1, 7).Select
ActiveCell.Copy Destination:=ActiveCell.FormulaR1C1 = "=(R[1])"

I am trying to copy from the selected cell and paste one cell below(next row) in same column.

View 2 Replies View Related

Copy Selected File To Specified Directory

Jul 23, 2013

Basically what I want to do is to create a button which when pressed opens a file picker (I think its called this way) and the user should find and select a pdf file. And when he does that he clicks "OK" and this file is copied to specified folder.

View 7 Replies View Related

Copy Selected Records From One Sheet To Another

Oct 31, 2008

I have a sheet with the pricelist and a sheet with the actual price offer. I would like to copy selected Items from the price list to the price offer. I dont want to do that by copy and paste method. I would like to create check boxes, so that I can check / uncheck each Item I want to be copied and then press the button copy to the price offer ... how can I do that. I asssume I would need a macro for that. The columns in the pricelist and the price offer sheet will be identical of course.

View 8 Replies View Related

Copy Selected Data Onto New Sheet...

Feb 18, 2009

I have a button the brings a dialog box with a list box. on selecting a figure in the listbox and clicking 'OK' the figure is transferred to a cell in a worksheet.

The column under this cell has a formula with the result True/False. The autofilter then selects only 'True', and then should copy the active range to a new sheet, preferably named according to the value first selected.

It must be possible for the user to have several of these ranges copied to different sheets for printing purposes, which is not a problem as this already works with the code.

View 3 Replies View Related

Macro To Copy Selected Columns

Aug 24, 2009

OK, I want to run a macro that will:

(1) go in to sheets 'A', 'B' and 'C'
(2) find all cells in row 1 that equal "1"
(3) copy the entire column and paste as values

View 13 Replies View Related

Copy And Paste Selected Checkbox

Mar 17, 2012

I was asked about if i can copy defined cells when i checked its checkbox by using vba button , and another button in another book to paste those cells .

Mention that i may select more than one checkbox in copying and when i would paste these checkboxes , they would be in queue.

View 1 Replies View Related

Copy Data From Selected Worksheets Only?

Nov 6, 2013

I am trying to work out how to copy all data from worksheets that begin with the name 'Sheet' and paste that information onto the next available blank cell in a workbook called 'Results'. I have found how to copy information from all worksheets to 'Results' but not from selected worksheets that begin with the name 'Sheet'.

View 6 Replies View Related

Why Won't This Selected Range Copy To Another Sheet?

Feb 23, 2007

I have a button on the Players worksheet that has this
Why would it not work?

Range("NewData").Range("B5:B" & Cells(Rows.Count, "B").End(xlUp).Row).Copy
Sheets("Players").Range("A3").PasteSpecial Paste:=xlValues

I am trying to copy Column B starting at B5 down to the last used cell in column B. into the players sheet starting at cell a3.

I try it and it highlights 4 cells and that is it???
Michael

View 9 Replies View Related

Copy Cells In Selected Row To New Sheet

Sep 9, 2008

I would like some code to allow the user to select any row in Sheet1
and then the populated cells (10 in every case) in that row will copy across to various locations in Sheet2.

eg,
The user selects Row header for Row 12 which has 10 cells ( A12 to J12) populated.
A12 will go to C3 on Sheet 2, B12 to D5, C12 to D9, etc, etc.

View 9 Replies View Related

Copy Selected Sheets To New Workbook

Jan 25, 2009

I have a workbook with about 25 sheets. All the sheets are named. I'd like either a Macro or some VBA code whcih, when the user clicks a button will Unhide selected sheets, say "Equip Labor", "Equipment", Proj. Summary" and "Implementation Guide" and then copy these sheets into a new workbook created on the fly (Book1.xls) and then in the original workbook re-hide all the selected sheets. This way the user can save the new workbook as whatever name they want.
Is this possible? The closest post I could find was this:
http://www.mrexcel.com/forum/showthr...opy+Worksheets
I tried to modify this, but I'm not that good yet with VBA.

View 9 Replies View Related

Copy Selected Range To A New Workbook

Mar 30, 2009

I have a code that will allow me to copy three worksheets from an open workbook to a new workbook. That works great, but I only need only a selected range from each of these worksheets to be copied (Range A1:AV60). Here is the code I use to select and copy the worksheets, how do I add a range within this code for each worksheet.

Sheets(Array("Req Page 1", "Req Ext 1", "Req Ext 2")).Copy

View 9 Replies View Related

Copy Cells To Right Of Selected Cell

Sep 15, 2009

I am using vlookup to get some data from one shhet in my workbook onto the front sheet
so I have a search box and the vlookup duly does as it should and gets me the data into E28:E100 and fills the cells to the right with corresponding data for each item
Now I select any cell from the first column of the search results I want and it gets pasted into the next empty cell range C4:C22 all this works a treat thanks to lots of help from mr excel. What I want to do (without any more vlookups) is pick up the corresponding cells to the right of the selected cell and paste them into the cells to the right of the pasted cell. I cant do it all at once because there is a different amount of columns between the select area and the paste area... hope this is clear
here is a snippet of code that lets me choose the cell to paste

Dim UserResponse as range
'InputBox to Ask the user to select the cell they want copying
'First direct them to the start cell in the column they are picking from
Range("E28").Select
On Error Resume Next
Set userResponse = Application.InputBox("Choose from List Below", Default:=Selection.Address, Type:=8)
On Error GoTo 0
If userResponse Is Nothing Then
End

Else
userResponse.Copy
(here I want to get the address of the cell into store so I can pick up the addresss of 2 cells to the right of it ie selected cell is E54 and I want to copy that and G54 and N24 and paste them into C8 D8 and F8 repectively)
End If

View 9 Replies View Related

How To Copy Selected Data From One Sheet To Another

Jan 28, 2010

Hi excel masters, I have questions on how to built a macro to copy selected the data from one sheet (contains data) to a summary sheet, I used excel 2007.

The macro I want to run to achive those result:
The data on the data sheet listed similar like below:

in first column (contains name) as below,
xx
xx
xx
xx
yy
yy
zz
zz
in the summary sheet, I want to copy one particular name from datasheet to cell A17 and below, based on the the selection criteria I enter in cell B1.

For example, if I want to show xx in summary sheet, I input xx in cell B1, and run macro to list xx one by one from A17, A18, A19....

I need to macro to run to search entire list to include the value I selected.

View 14 Replies View Related

Copy User Selected Sheets

Jun 5, 2006

how you would write a macro to move a selection of sheets to a workbook called Digi's in the D drive. Also if there isn't a Workbook called Digi's already it needs to add one. I've found some code to loop through sheets but nothing to show what sheets the user has selected

View 4 Replies View Related

Copy Selected Cells From One Sheet To Other

Nov 20, 2006

i need to copy the selected cells, and paste them on another sheet on same locations, this should be done on button click

View 6 Replies View Related

Copy Selected Rows To Another Sheet

Nov 30, 2006

I need to copy only user selected rows ( multiple) from one sheet to another. I see similar threads here but none that work with user selected rows.

View 4 Replies View Related

Copy Selected Range To New Workbook

Sep 13, 2007

I am trying to create a method to select the values of contiguous range selections on excel worksheets.

Users will be making new worksheets in new workbooks out of the data from the old sheets.

Currently users make a selection is and copy it to a new worksheet.

Is it possible to retrieve from the 'clipboard', the values from the associated cells?

And then to parse them into columns in a new worksheet?

Earlier I tried this bit of ( it didnt work )

Sub AddNew()
' for passing highlighted text into the form so that I can pass it
'to a new workbook.
Dim PassData1 As String
Selection.Value = PassData1
Set NewBook = Workbooks.Add
With NewBook
.Title = "xxx"
. SaveAs Filename:="xxx.xls"
End With
Range("A1").Value = PassData1
End Sub

View 9 Replies View Related

Copy Selected Text From TextBox

Mar 11, 2008

I have a userform in which I wish to use custom buttons for several commands. My userform users aren't going to be very computer skilled and may not know the CTRL+C or CTRL+V command so I am hoping to put in small image buttons representing each command to be able to copy (and paste if necessary) their selection in a TextBox on a MultiPage'd UserForm.

Is there any way of doing this? I've had a look through the forums and seen several examples of how it can be possible to copy and paste but not in the method I'd prefer to have it on this UserForm.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved