range copy

  1. T

    Transfer data from one range to another using array

    Hi, can anyone spot the error in my ways on this? I've been on it for hours! Essentially looking to copy data from Raw Data to Table5 which is on a separate sheet - but without using copy and paste that is taking way too long for my 20,000 rows and 85 columns of data. Any help will be greatly...
  2. S

    Copy table Column data using a Macro

    Is anyone able to assist in copying a the data of a table column only. I have a macro which runs a bunch of filters and from there I would like to copy and paste the column data only (no headers) I specifically need help with copying and pasting the data. Sub CopyData() With...
  3. S

    Value Of Cells to Names of Worksheets

    Guys, I have names in a range of cells (B9:B72) in a workbook called Master Schedule. I need separate worksheets for each of these names. If possible, I'd like to create a function that creates new sheets and names them according to the range of cells in this workbook. If further...
  4. K

    Copy-Paste Range (Macro Vba)

    Hi all! How do I copy-paste range A1:L16, every time, until row 500? Can you help me build a simple VBA/Macro? Thanks.
  5. R

    Compare a list with sheetnames and on match do copy-transpose operations

    Hi! I have a problem. I have a Workbook named 'SalesData.xlsx' which contains two sheets 'Demand' and 'Availability'. Column A of these worksheets contains CUSTOMER names and remaining thirteen columns contain month-year data. The following needs to be done with both sheets i.e. 'Demand' and...
  6. U

    Why can I not copy a range from another sheet?

    From another worksheet I can copy columns from: OWs.Cells(HdrRow, CCol).EntireColumn.Copy and I copy cells and rows from other sheets so why can I not copy a Range? FWs.Range(Cells(FLRow, FSC), Cells(FLRow, FLC)).Copy When I try I get the error: "Method...
  7. A

    HELP! copying ranges before update vba

    Hey, I have a 25 row table stretching into many columns arranging monthly data from 2008 to 2015. Now from march 2013 onwards, i have the following formula, which updates the value if its an actual value, or uses a formula to forecast. I want to copy these entire range of columns to another...
  8. T

    Range syntax question

    How do I set a range for something like this: myRange=invsheet (iRow "A"), (iRow "D"), (iRow "H"), (iRow "K"). copy BatchSheet.Cells(oRow, "D").PasteSpecial xlPasteValues where the range is made up of non contiguous cells. I would really appreciate some help on the syntax. Thanks...
  9. D

    Columns to columns

    I have a data list Item List 4/07/10 Blank 04/15/10 Blank YTD Soap 3 Blank 2 5 Tp 3 Blank 3 6 PT...
  10. J

    Range copy to a new worksheet

    I have an excel file contains 8 sheet. I would like to copy full details to a new excel new file if 2 values are not equel. Suppose Cast Quantity <> Delivery then I want to copy it to a new excel file. All 8 sheets should check then result should come with Head Lines to New File (Sheet1) one...
  11. W

    vba copy rounded sum of range to another workbook

    Hi All, I'd like to copy the sum of a range from one workbook and paste the rounded value into another workbook. Not too sure how to code this in VBA... E.g. Source workbook Cell A1: 100,000,000 Cell A2: 200,000,000 Cell A3: 300,000,000 Sum = 600,000,000 Destination workbook Cell A1: 600...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top