copy rows

  1. J

    Copy Row(s) based on cell data from one sheet to another, shifting cells down.

    Hello and thank you in advance for the help,+ I will try and explain this the best i can without confusing anyone to include myself. I have a workbook of sheet1:sheet5. Sheet1:sheet4 has data that i would like to consolidate on sheet5 based on cell values in columnA from the other for sheets...
  2. N

    Dynamic Row copy (Create 1-4 copies of row based on count of items in a table)

    Hello all, Looking to make a dynamic tool which can take a static list and copy it 1-4 times (also inserting data from a small table) I have a list of 30 student names in column A. In columns C:E I have a small table with the following data: C: Class name D: Instructor E: Credits <tbody>...
  3. S

    Using Checkboxes to Copy Rows From One Sheet to Another in the Same Order That They Appear

    Hi everyone, I'm fairly new to VBA so this doesn't seem obvious to me at the moment. I've managed to use Checkboxes to copy the rows that have a check mark from sheet1 to sheet2. The problem is that if I insert a new row in sheet1 somewhere in the middle of the worksheet and I insert a...
  4. J

    Make this Macro Work with more rows?

    I have created a macro that works, but it only works with my specific example data. If there are more or less rows, or different data in the cells, it will not work because it is not written dynamically. I lack the skillset to make it dynamic also :) Link Example data containing Macro...
  5. J

    Copy varying number of rows from one sheet to another depending on cell reference

    Hi - I am attempting to come up with a code to copy a varying number of rows from a "Template" worksheet to multiple sheets in my workbook depending on a cell reference on each sheet. So, for each sheet in the workbook that begins with "Labor BOE", look at the number in cell "L2", copy that...
  6. S

    vba to Copy row!

    Hello Can anyone figure out why the following code to copy row("10:10") showing an error?!! Sheets("TST").Rows(10).SpecialCells(xlCellTypeConstants, 23).Copy _ Destination: MM.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=True :eeek:
  7. L

    Not sure why my simple copy rows is running so slowly

    Hello, Maybe someone here will be kind enough to help me. I have a simple subroutine but it runs incredibly slowly. I have one sheet CodeName "SellHack". For now there are about 700 Rows. About half of the records have "verified" listed on Column "O". I'm trying to copy all of the rows...
  8. F

    Copying formulas that only grab particular ranges

    I found some previously solved posts that are similar to what I need, but I am having trouble making their solutions work for myself. I would really appreciate anyone's help! Here's the scenario: I have created a report that holds the grades of certain calls that have a corresponding reference...
  9. D

    Update different sheets . VBA

    I'm new to all VBA concepts so I really need help. I have a file with 3 sheets. The first one contains clients from the UK and FR (this being column 3) , the second one clients only from the UK and the third one clients only from FR. I want a code that will update the second and third sheet once...
  10. A

    Copy rows from workbook A to another workbook B based on the column value in workbook A

    Hi, Could someone help me in achieving this. I require this to accomplish my project task. I am still a beginner in writing VBA and did lot of research over the internet and still empty handed. :( I have the below data in workbook A in worksheet Sheet1. <tbody>...
  11. A

    Select a specific value from text box and search in a column of excel

    Dear All, I have a worksheet "database" which is database of patient information in each row, in column H I have the "pateint IP number" I have a userform for search and copy. The textbox in the userform is "search_tb1", where I would input the required IP number and search in column H for a...
  12. T

    Need Help ASAP! Find Multiple Values in One Column, Then Copy Each Entire Row Containing the Values to New Sheet

    I keep coming across the need for this macro in my work projects, so I would be very appreciate to anyone who can help. I have a sheet containing multiple columns, multiple rows. Column A contains a research participants Subject ID#, and the rest of the rows contain data (gender, visit date...
  13. F

    Subtotals - Show other data in subtotal line

    I often have spreadsheet with many columns on which sub-totals are calculated in 1 or 2 columns. Excel posts xxxTotal in the columns on which the sub-total is based. If you collapse the table to only show the subtotals, the rest of the fields are hidden. I would like to see all the data of the...
  14. N

    Copy data from one sheet to another using a specific criterion

    Hi Guys, I'm looking to copy over information from a master list of data by specifcying a specific criteria. For example: In the info below... there's a number of Index types. I would like the code to look at the range that is all of Column C (cell by cell) and look for "AS51", if its there...
  15. N

    VBA: Filter and Copy Data into Next Available Row

    Hi all, I have a macro which I am working on that imports a large text file into Excel. This text file then needs to be separated into two sheets "Tyres" and "Mechanical". I have got so far as to import the file, then show which rows need to be transferred to which sheets, but am stuck on how I...
  16. N

    VBA: Copy Row from One Workbook to Another

    I have a code which I use to import a large text file into as many worksheets as necessary. Text to Column is then run on these sheets and a formula added into Column I which returns TRUE or FALSE. What I need my to do next is select any rows where the value in Cell I is TRUE and paste this...
  17. J

    Copy subtotal rows to new sheet. Stumped

    I have been looking long and hard for a vba code to copy the subtotal rows in my worksheet to a new sheet and I am stumped. My worksheet ("Analysis1") has 15 columns and rows which keep accumulating as data is enterd. I have autofiltered the sheet already to consider the rows I need only. I...
  18. A

    Copy filtered rows

    Hi, I got a spreadsheet with following details name, address, city, postcode, phone and email I would like to get rows that email filed is blank into separate spreadsheet, so I can send them a letter. How can I get just these rows? thanks a lot for your help
  19. C

    Copy Rows from individual Sheets and paste the same in a new sheet in excel using VBA

    Hi Experts, I am a novice in using VBA or Macros in excel. I need a help in copying all the available rows from Individual Sheet say A, B & C that needs to be copied to Sheet D in the given below fashion in a Worksheet: Copy Row1 from Sheet A Copy Row1 from Sheet B Copy Row1 from Sheet C...
  20. W

    Copy Rows Based on Cell Value (time) :: Macro help

    We are (pivot) charting the amount of tv spots purchased per hour. sometimes programs are purchased in blocks larger than one hour. These blocks need to be broken down into average quantity per hour. Each Row includes a Television Program (column F), start time (H), end time (I), and a total...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top