copy

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top