copy

  1. E

    Copy paste specific cells from a row based on cell value of column C

    Hi Everyone, I am new to the forum and I am great at Excel - whilst also being terrible at VBA! Which I guess in itself is an oxymoron. I am really stuck. I need to paste information from columns on one sheet to columns on another (not entire rows and in a different order). The source...
  2. C

    VBA / Macro Copy, Paste, Loop

    Hi All A little help please for a complete VBA / Macro novice. I am trying to automate the coping of data from one sheet to another whereby the macro I have takes all the data in the first data row (row 2) of sheet 1 ("Standard report - Items"), copies this to a new sheet, then selectively...
  3. S

    Paste Multiple Selections

    Hi, I'd like to be able to paste two ranges from another workbook (the data source) to a final workbook using with two macro buttons (one in each) one will say copy and the other paste (in the final workbook). Copying seems to be okay as you can do something like the below or use a Union...
  4. D

    Selective copying based on criteria

    Hi guys! I have kind of a complex question. It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD). Much of this data is pretty useless to me, to be honest. But there are a few pieces of information that I want to extract (if the row...
  5. M

    Copying Data and Graphs - Graph data is staying linked to the copy source rather than the paste data

    Hi All, I have a series of data that is linked dynamically to a cell in a drop down - Cell A1 is the drop down cell. The resultant data is then used to create a series of Excel Graphs. Both the data and graphs run from Row 1 thru 40. I copy this data, from column 1 thru 40, to row 41 thru 80...
  6. E

    Problem with macro to copy vba to new workbook

    Hi, I don't know if anyone can help, I am not that experienced when it comes to VBA, I have found the following code online & modified it slightly to fit my needs. I am trying to copy a module called PrintQTYPAGESASCELL() If I am honest, I don't understand what each line is doing, I think I am...
  7. S

    Define a list of files as a variable target (VBA)

    Hello, I use a code to copy files to a template file, and delete old one, then save as old file's name. But choosing every single file for like 500 files, is very boring. Since, I do this operation once a week, now I need more clever way to do it. I use "GetOpenFilename" in order to choose...
  8. M

    Convert VBA Application.Filesearch Copy/Paste

    I am trying to update some old code I used years ago to work in a current process. The code below, for every source workbook in the same folder, will open, copy a specific range, paste that range in a summary/master workbook, and close the source document. It loops through this process for all...
  9. S

    Copy and paste at each change in data

    Hi Folks, Looking for Some code to copy and paste but each time the data changes to fill in the blanks. So in column a and b have are the range. I want the code to copy a and a and paste it to the where b starts... then copy b and b and copy that to c.... and so on (the values in them cells is...
  10. G

    VBA Loop for copy and paste with search

    Hi There, Thank you in advance for taking the time to read this. I've tried to search for the answer but to no avail so I'm hoping some very kind person will be able to help put me out of my misery. I'm trying to search for a specific term within a column of a worksheet, if that is found...
  11. D

    Unable to paste in tables

    Hello, I have a large table inside Excel (J1:BZ4597) The data is in an actual Table (it is not just a range of data) (if you click anywhere in the table the Table Tools tab appears in the top ribbon). Even though it is a large table I have never had issues before now. All of the sudden I am...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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 =...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top