copy data column

  1. C

    Copy all rows that have value in selected column range to another Worksheet.

    Hi VBA experts, I have two worksheets, the 1st one is SourceFile, the 2nd one is CopyFile. I have created the code to create sheets in CopyFile based on cell values. I need some helps from you to copy data from Columns Range of SourceFile to cell A1 of CopyFile. I will fill in SheetName...
  2. P

    Need macro code for copying some data from one sheet to another

    hello, I need to copy some data from one sheet to another. Suppose, Sheet A is having multiple column; out of that I need to copy column2, column6 and column8 data to another Sheet B to its column 1 ;column2; column3. Please give me a detailed step to execute the code...as I am very new to this...
  3. F

    Autofill a VLookup Formula to the last row of data

    Hi, I am having some trouble creating a macro to copy a vlookup formula from the 1st line of data (G2) all the way to the last row. I can easily create the VLOOKUP statement: =VLOOKUP(A2,HIST!A$2:H$269,8,FALSE) However this has 2 problems, firstly the range size will change, depending on...
  4. D

    auto copy newly inputted data to another column

    Hi, Is it possible to input data into a specific cell, say A2 on worksheet 1, and the data be automatically copied to columnA on worksheet 2, and listed. e.g: If I enter a value of 5.01 in A2 (ws1), press return. In the same cell type 10.3, return, In the same cell type 20.5, return. Then...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top