copy row between sheets

  1. S

    Copy rows to another Sheet position

    Hello :) I am wondering how this can be done: I want to copy a specific rows from Sheet A into a specific row-position in Sheet B with variables. I think the idea is simple but I can't solve it: I am looking in Sheet B for values > 0 through a column ,top down. If there is a value (e.g. = 4)...
  2. S

    Copy excel row from one worksheet to another based on cell contents

    I'm fairly new to VBA and thus I need some help with this. I've looked online countless times but I can never seem to find exactly what i'm looking for (or it doesn't work at all). I have an excel workbook with two tabs - Activities and Travel. Whenever a number (other than 0) is entered into...
  3. D

    VBA to copy values in a row and paste them in row on separate worksheet

    I need help with a VBA to copy a row of #'s from one worksheet to another. It will be a daily process so I will need the new row to go below the day prior if that makes sense.
  4. K

    Copy row when a certain value is on Sheet1 to Sheet2

    Hi I am new to VBA. and need a lots of help to make it work. The first Sheet (Everything) got everything, and when i put a value under department like Miami then i want to copy the entire row to my Sheet called Miami. And so on. I have googled it and watched some youtube, but i cant figure out...
  5. A

    VBA - Using asterisks when searching for number

    hello! I have a column of numbers in the form of 70.00.01.0024, 70.00.01.0013, 71.00.00.0013, 71.00.00.0024, etc. What im trying to do is, find the cells and cut the rows that they are at (e.g. B1:B4). I tried doing that searching 70.**.**.**24 but doesn't work. here's what I have so far...
  6. A

    Copy ROW from one spreadsheet to another

    I have a report I am working on. One sheet named "BlueSkyDATA" has the raw data I am pulling from. It has 19 columns (A-S) and hundreds of rows. If the time data in column K is greater than or equal to 1 hour, I would like that whole row to be copied to another spreadsheet in the same...
  7. L

    Copy an entire row based on conditions in a cell , please !!

    Hi People, as this is my first post I don't want to sound dumb, so i'll make it as painless as possible. I have a workbook with an "Data entry sheet" and a "Copied data sheet". Is there a way to copy and paste the row where one cell has a "Y" in it automatically . I have explained inside the...
  8. D

    copy a row if cell contains data

    I am having a hard time finding a good solution for this. I need to simply copy an entire row and paste it to the end of a row of another sheet. logic: if cell contains date between today()-120 then copy entire row and paste row at the bottom of another sheet. lol I hope that makes...
  9. M

    Moving Rows to Other Sheets Based on Values in the First Column?

    I'm new to Excel Macros but not to programming. I have some training in C, C++, IDL and HTML. However, I'm still muddling about trying to get a handle to the syntax and capabilities of VBA. As far as my question is concerned, I have a master sheet with 22 columns of data. Time, a categorical...
  10. M

    Copy Entire Row to another worksheet if Sum in a cell is greater than a certain number

    Hi! I am wondering if it is possible to have excel copy an entire row to another worksheet if the sum in a cell is greater than a certain number. Here is what I am doing. I have one sheet that lists every person's name that is participating in an event that is going on. On that sheet it will...
  11. B

    Copy complete row into another sheet based on data from drop down menu

    I have a simple spreadsheet in Excel 2013 of a workplan in sheet 1. In Column H, you can choose from a drop down menu who needs to be working on certain tasks. Because the list of activities is long, I want to copy the whole row to Sheet 2 whenever SM is chosen in column H. I have never worked...
  12. M

    Auto copy entire row, possibly using IF function

    Hi I am stuck with a little problem. I have a window cleaning business and am trying to get excel to automate my routes. What I have now: Tab1 (Sheet:Costumers) <tbody> <tbody> A B C D E F G H I J K L M N O P Q 1 # Streetname Street# Town Zip code Name Phone1 Phone2 Total Price...
  13. W

    Macro to copy rows to new worksheet without repeating itself

    Hi, I have searched through the forums and found a macro that will search one column for a word, copy the row, and paste it onto a new worksheet: Sub COPYROW() Dim rcnt As Long, result As Long rcnt = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row result = Sheets("Sheet2").Range("A" &...
  14. N

    Excel 07 VBA Resize Message Box Prompt Error

    Hello all, I seem to be having an error, I am running code that loops through column AR, checks for a value and if the value is present, copy and paste the row to a corresponding sheet. I am using the Resize function to define how many cells of the row I wish to copy. However, for some reason...
  15. S

    Help with simple row copying macro

    Hi, all: I'm using a macro to check if a column contains data, and if so, copy its row to another worksheet. It's working great as long as there's data in the column I'm searching. If there's no data in that column, instead of doing nothing, it copies the header row over. How can I prevent...
  16. S

    Macro to copy specific rows to another workbook

    Hi everyone, I'm trying to automate my data organisation process, so what I'm looking for is a macro template with the lines of code I need, but for me to change the names of the files. So, what I'm trying to do, is: 1. tell it to look in "workbook 1 name" in "sheet 1 name". 2. copy row 1 and...
  17. M

    Creating order form in Excel 2007; Need to copy entire row if one cell has data

    Good afternoon, I'm trying to create a very simple order form, and would appreciate some assistance. It's been a while since I've done this in Excel, and I couldn't find an answer when I searched. (I may be a lousy searcher, though.) I want the user to enter a quantity in Column E of the...
  18. L

    Copy Data From Individual Sheets To Main Sheet

    Hi Friends I have been working on a macro which copies data from individual sheets to the Master sheet. In a easy way out I created the below given macro which copies all the data from individual sheets to a new sheet and rename it as Master sheet. But there are practical issues in it. So rather...
  19. Tuggles

    Copy row data between sheets when duplicate value is inserted in other sheet

    Hi all. Have been trying to get my head around vba but unsuccessful so far. Hopefully somebody can help. I am using excel 2003 on XP & have attached sample workbook. I’m trying to setup up a document to track stock. There are two sheets “Stock” & “Allocation” which both will go from row 2 - 999...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top