copy row

Hi All, I'm new to VBA, I have a range of values (unique value for each person) I want excel to know the exact value and select it in (sheet1) then copy the entire row of that value to (sheet2) and delete that row from the (sheet1). can you please provide me with correct VBA code? Thank you..

Hi, could really use some help with this. (hopefully not as dumb as question as last time! I am trying to write a macro that will search through a load of sheets for a value in column L, and if it finds that value, copy the whole row (and repeat for all non blank rows in sheet) I will need to...

Hi There, Can anyone help me out here I'm just getting started with formulas in Excel. I have an Equipment register containing particular information but this equipment gets moved around. I would like to know how I can get an entire row to copy into another worksheet if I enter the...

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...

Hello friends, I have been working on this code, but am having trouble finishing it up. It works well now, but I still need a few things. 1. I want the code to run automatically whenever column N has is edited on the source sheet "all positions". 2. This is to include addition OR deletion...

I'm urgently trying to automate a vlookup scenario. I have Dates in cloumns in short date format in Tab Subs Week and in Tab named Cinema-Data have Dates and 6 rows of Data in cross tab format. All I want to do is if Dates in Subsweek match Dates in Cinema-Data then I want to copy the...

This below is the Sheet1 <tbody> Model Brand Status Quantity Minimal Quantity a1 Asus In stock 2 1 a2 Sony In stock 1 1 a3 Toshiba Test 3 1 a4 Fujitsu Test 1 1 </tbody> I want to separate in different Sheet according to status.If status=In stock then copy the row and paste it to...

This below is the Sheet1 <tbody> Model Brand Status Quantity Minimal Quantity a1 Asus In stock 2 1 a2 Sony In stock 1 1 a3 Toshiba Test 3 1 a4 Fujitsu Test 1 1 </tbody> I want to separate in different Sheet according to status.If status=In stock then copy the row and paste it to...

Hello, I have a sheet codename "qm". There are rows of customer contact information. I need to be able to use autofilter to copy two types of records. Is it possible to do this with Autofilter? 1.) The contacts in which this row represents the only contact at a company. (i.e. The company...

Hi All! Here's what I'm hoping some of you wizards can help me with: My Boss' wife has a mailing list in Excel which exceeds 500 entries. The Master list contains all the addresses. Columns 9 - 13 have designations of x, g, c, j, and p. If the person gets a mailing for Christmas, an "x" is...

Hello people, I need help with a code that copy the first row from the sheet sheetname"test" and put it on row 1 into the sheetname "Statistics" Could someone help me? Thank you in advance

How do I say: If column T has a 0, move that rows column J-S onto sheet2 on en empty row. Thanks!

Evening MrExcel Community, Well now it appears it's morning. I'm fairly decent with most things non VBA on excel but the VBA side I don't really know much about. Apparently this is my next area to learn. I have an excel sheet that I update the main info from another database by deleting the...

Hi, I'm trying to teach myself to write in VBA but many hours have shown this problem is way above my abilities at the moment. I have a very long list in a worksheet where column F contains one or more pipe diameter, and if there is more than one diameter for that particular line the cell...

Hello, I am hoping to copy Rows from sheets 1-12 to sheet 13, if cell value in J is greater than zero. I want to hard-link this data with sheet 13, which I will call "Outstanding." So, any changes in sheet 13 will be reflected in their respective sheet (1-12). Is this possible? Thank you so...

Hi, I have been looking for some code to find a row within "Sheet1" containing a word with a question mark next to it and then copy that row and the row above to the next worksheet "Sheet2". I have tried other peoples codes but they dont incorporate finding part of a word. Below is the code I...

I need to create VBA that will insert & copy current row if value in column D>0 & do this all the the way to the end. I need VBA that will work as VLOOKUP but for multilines. Let's say A7="Paris" Sheet1. I need to copy a all values (if A7="Paris") from sheet2 column B, C, D etc.

I've been trying (for HOURS) to achieve the following goal: Need to take the first three cells of rows and copy them to a different worksheet when the word "Alex" appears in column B. I've tried editing the following macro that copies the whole row but nothing I change the entire row.copy...

<tbody> header test details a alpha 10 a beta 400 b zoo 32 b gamma 500 </tbody> Hello there, I have this spreadsheet starting in A1 with a header row. Then I have another row in row 2 ( a-alpha-10 in my example ), then one empty row every two rows. ( so row a-beta-400...

Good day to all With this code i search in Sheets("data") for -1, copy that entire row to Sheets("Result"), delete the row and sort the sheets("data"). Sub Transfer() Dim c As Long Dim wsD As Worksheet: Set wsD = Worksheets("Data") 'Data Worksheet. Dim wsR As Worksheet: Set wsR...