copy

  1. M

    Create a new folder based on cell and copy list of file into created folder

    Greetings, I am new in the VBA excel. I would like to ask to everyone. I have a list of document with .pdf extension (in column A1:A20). I want to copy all documents from source folder (in my disk C:) to destination folder (in disk D:). The destination folder is a new folder that named by cell...
  2. S

    searching for data in columns with the same argument

    Hello. I am trying to copy/paste data from 2 columns (containing several rows with required data) and transfer the columns to another worksheet in the workbook over a time span of either 23-24-or 25 hrs The problem is that I need to use an argument what is not consistent and I have a macro in...
  3. M

    Excel Table Copy Paste Sheet

    Hello Excel Wizards, I have several formulas that reference another sheet in my workbook. I routinely receive an email from my customer with their worksheet in an attachment. So to update my sheet, I simply copy and paste the entire sheet. I did it this way because the rows can vary between 200...
  4. M

    Keep source formatting when pasting ranges to a shape

    Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...
  5. M

    copying images from one folder and pasting in another based on schedule in excel file

    Hi guys Hope you all well and safe from Covid. while in lockdown im hoping someone can assist me with this query. i had a macro created whereby image product code is listed in Column A, Column B lists the location of that particular image and Column C displays the location of where i want...
  6. F

    1004 Excel Cannot Paste Data (Pictures) To Workbook

    Hey All, Would you be so kind please and help me figure out why the below code only works from time to time but more often than not throws the 1004 error? All I'm trying to do is copy charts without links from one workbook to another. Sheets.Add(After:=Sheets(name1)).Name = charts...
  7. M

    Find, Copy and Paste across all worksheets

    Hi, I'm really need help with this. Been trying to achieve this for the last 2 days. On my first worksheet, I have Values in column A and column B there are also values but they are hyperlinks. I'm trying to find the cells with the values from A across the rest of my worksheets and and replace...
  8. M

    Copying cell range (if not blank) to new row in table

    Hello, first post here - I'm not overly familiar with VBA but would really appreciate some help with this task - Background - I've created a fixed range of cells (on a "Submit" sheet) where a user can quickly input some data as required. The sheet is seven columns (with headings) with enough...
  9. E

    Find last row of data in column A on a specific sheet, and after that copy data down to that row on another sheet.

    I am almost there I think. But this seems to search for data in all columns on the first sheet. I only want to check column A on Sheet 1. Sub FindLastRow() Dim LastRow As Long With Sheets("Sheet 1") If WorksheetFunction.CountA(.Cells) > 0 Then 'Search for any entry, by searching backwards...
  10. C

    Combine lists with similar headers

    I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...
  11. A

    Copy data from another column (Only for Visible cells)

    Hello Guys, I Need to Map the data from one column to another column. Example: Consider there are two columns A and B where i need to Map the data present in B to A. I took the ColumnName (Column B) as ColLtr_Customer and Current row in Column A as currrow and entered the formula as show below...
  12. M

    Google Sheets | Edit row of data if duplicate found

    Good afternoon, I have this code that copies to sheet "INVOICE_ENTRY" any row in the range A5:P if it finds a value in column N. "INVOICE_ENTRY" sheet is identical to the srcSheet, except it has a couple more columns after P. What I want to happen is after running the script, if it finds a...
  13. N

    VBA Copy, Find and Paste Values to Different Sheet

    Hi All, I have a file which is essentially a record of projects (+150) e.g. project title, leader, start date etc., and there is a second sheet containing some formulas to calculate project value. I'd like to be able to copy the calculations from sheet 2, and paste them as values on a specific...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top