1. bepedicino

    VBA, Copy, Remove Ants, Keep Clipboard

    I have the following VBA which copies a dynamic range. However, I want to clear the marching ants, but retain the clipboard so I can paste into another application. Can anyone assist? Sub CopyData() Dim a As Integer a = Sheets("Classification").Range("A" & Rows.Count).End(xlUp).Row...
  2. R

    VBA - Copy row based on text in cell to a new sheet into first empty row

    Dear all, I've been looking high and low for a macro that will help me copy a certain row based a specific string in a cell to a new sheet and the first empty row in that sheet. Please help me figure this out. Context: - One Excel file - Two sheets "JiraData" and "Dash". Please note that...
  3. M

    Click on multiple cells from multiple sheets and copy range to new sheet in order

    Hey, I have very small knowledge of writing vba from scratch, but am ok editing info to suit my needs so any help would be much appreciated. I’d like to be able to go through an excel document that has multiple sheets and as I’m clicking cells they are copying a range of cells relating to the...
  4. I

    Copy rows from dataset with data input on one sheet based on another sheet's criteria. [VBA]

    Hi all, I have 3 sheets: "Input","dataset","Print" My objective is to input a few data in "input" Column A and run the macro. If any cell in Column A of "Dataset" = "input" Column A, it will print out the whole row results to "Print". I found many examples of copying rows into another sheet...
  5. J

    Copying data with same headers from sheet 2 to sheet 1. VBA???

    Hello everyone. I have had this issue for about a week now and it has been killing me slowly. What I am trying to do is move data from “sheet 2” to “sheet 1”. I only need the values to move over from sheet2 to sheet1 (the headers are the same). For example, on both sheets lets say I have...
  6. S

    Copying a worksheet from a closed workbook to the active one

    Hi all, I want to copy a sheet from a workbook I have saved to the one I am currently working on. I need this code to be able to do this in any workbook I am working on. The code so far is as such: Dim sourceBook As Workbook Application.ScreenUpdating = False Set sourceBook =...
  7. B

    copy data between workbooks

    I am looking for a formula of VBA if not possible. I will have 7 workbooks (from different users) and one master. They are all clones so have on one register sheet that has the same columns. The data will be different and the number of rows will change. At any point in time the master needs...
  8. P

    vba copy and paste number of times based off cell value

    I cant figure a vba code to do the following: --------sheet1----------- -----(A)---------(B)------ -----Qty.----Description 1]----3---------sofa----- 2]----1---------chair---- 3]----5---------table---- based on (sheet1 column A's value)......copy and paste (sheet1 column B's value) onto sheet2...
  9. N

    Copy, Paste into different worksheet until last row and Print

    Hi Members of MrExcel, I am in need of help and unable to loop my sheet. I have a workbook with 3 sheets 1) Input 2) Front 3) Printt In the "Input" i have to columns G and H with Dates for the month I am trying to paste the value from Sheets("Input").Range("G2") into Sheet...
  10. D

    Copy Paste two rows to two separate areas on another sheet

    I have Excel 2013. I need a macro that will do the following. I have two rows that need to be copied to another sheet, say "XXXYYY" at the bottom of different columns, in the first unoccupied row, depending on the name in cells C7 and C8 Row one occupies A7:J7 Row two occupies A8:J8 If the row...
  11. G

    VBA Copy data to another work book based on CONDITIONS

    Hi Team, I would like to copy data from one work book to another. The data has to be copied from BookA to BookB. However, the issue is that I am not allowed to edit the vba in BookB. Book A has a list of names and their forecasts. Book B also has a list of names and forecast but it also has a...
  12. StephenArg

    Copy contiguous columns, paste to non-contiguous columns

    Hi there, I have a workbook with integers stored in 6 contiguous columns and 3 rows. ("source WB") For example: A1:F3. However, this range changes from week to week, so the selection of the source range needs to be dynamic. I have another workbook ("destination WB") where I want to paste...
  13. L

    VBA - copy new rows from different sheet, if condition is met

    Hi, I am VBA Excel coder since yesterday and I am stuck. Hopefully you can help me. I am managing sports team and want to follow players training progress. I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From...
  14. A

    Copy paste from Sheet1 to Sheet2

    Dear Excel Experts, I have a Data in Sheet1, I want to copy some columns to Sheet2 as per below condition. In Sheet1 from cell AC15 Employees Date of Birth, I want to copy columns C, D, E, F, I and AB from 15th row and paste to Sheet2 of column B, C, D, E, G, And F respectively to 10th row if...
  15. willow1985

    VBA Copy visible cells as a picture

    Hello, I have a macro that filters column Q removing blank cells. Once it is filtered to show only the cells with data I am looking for a code that will copy all visible cells from Q2 down and copy them as a picture. Any idea what code I could use? Thank you for all your help! Carla
  16. L

    VBA - Save Copy of Worksheet to Specific File Path AFTER Data Refresh

    To the VBA experts: I need VBA code that will take the active worksheet (Sheet1), the only worksheet in the workbook, and copy and paste the values into a new workbook and save to a specified directory/folder, after I do a Data-Refresh All. It's essentially archiving a copy each time the data...
  17. D

    How to copy multiple rows using If

    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need to replicate this for the 19 rows beneath this. Do I need to Keep writing the same code for each row or can I write a code to cover all the rows...
  18. D

    Copy and Paste Multiple Times

    I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here: Sub CopyMulti() Range("A3:D19").Copy Range("E15").Resize(14 *...
  19. M

    Filter, copy and paste into another sheet

    Hi, I've been creating a macro to filter on column N in the Raw Data tab and then copy and paste columns A-J into the Report Log at the bottom. It works, except theres currently one result with Check in Column N but it is copy and pasting this in twice. Any idea why? Sub...
  20. T

    don't copy sheet with specific name

    how to not copy a sheet with specific name please, thanks!

Some videos you may like

This Week's Hot Topics