copy & paste vba code

  1. 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.
  2. N

    copy cell on double click to another worksheet

    Hello, I know there are other threads on this subject, but because of my poor knowledge in vba I couldn't adapt the answers to my problem. What I need: WhenI give two clicks in a cell (c3:d10, worksheet"PM") , copy the cell's value and paste on D1, worksheet"PLANEJAMENTO". Thank you.
  3. F

    Copy columns

    hi, while I`m running below code I`m getting error like: run-time error 1004 select method of Range class failed Application.ScreenUpdating = False Application.DisplayAlerts = False Dim wsC As Worksheet Dim wbC As Workbook Set wbC = ActiveWorkbook Set wsC = wbC.Worksheets("ABC")...
  4. L

    Macro to copy paste info from every other cell

    I have a table like this: <tbody> 1/2/14 2345 1/6/14 34665 1/7/14 5473457 </tbody> For Column A-I would like to create a macro that will copy the info from cell A1 and paste in in A2. This will continue all the way to the last row containing info which will...
  5. R

    Copy date from one workbook into other workbooks located in another folder, there is a common reference no. between them

    I need to pull the date from one workbook called “log” (the date is in column B) and display it in another workbook (one of which is) called “MrepoA” . I will have approx 8 workbooks in a folder called: MrepoA, MrepoB, MrepoC , etc. that need to receive date information from the “log”...
  6. R

    VBA Copy cells from non-contiguous ranges to paste on another sheet

    Hello, I am trying to build a code that copy cells from non-contiguous ranges and paste the data on another sheet where the cells are contiguous. The ranges have more than one column but I just want to copy the data from one column (for example the first column). This is the code I have for now...
  7. S

    fyi Excel 2007 vs 2010 cut/paste behaviour change

    Just thought I'd share this nugget of information. VBA based cut/paste of a range containing a form button has slightly different behaviour in Excel 2010 vs Excel 2007. If the source range is hidden the button will NOT be copied when using 2010 but will be copied when using 2007.
  8. A

    Copy formula paste value

    Hi, I'm pretty new in the VBA World and was hoping somebody could help me with this problem. I have two worksheets: "worksheet1" containing the current data (e.g. today's progress) I want to copy and "worksheet2" containing historical data (e.g. historical progress) in which I would like to...
  9. E

    Re-post [VBA] Copy selection to multiple worksheets except two

    Can someone please help me? In the last part of the code I want to copy a selection from 1 worksheets to all other worksheets except two. But the macro stops at the selection and doesn't copy at all. I get no error message. Can someone please tell me what the correct code should be? Thx...
  10. L

    VBA to Copy & paste values in a new sheet in a new workbook.

    Hi all. I Have a weekly timesheet that I have automated using vba. What happens is that from a master timesheet I copy the current worksheet into a new workbook for emailing. When I have the new sheet in the new workbook I want to copy & paste values that in the master timesheet rely on a...
  11. R

    Macro to copy from Sh1 (triggered by an entry), paste in Sh2 but also integrating it into existing code

    Hi: I need help with writing a new macro and integrating it into some existing code. My existing code works well for creating an auto hyperlink, from one sheet to another, triggerered by a dropdown value in Sh1 column K. I'm trying to add vba code to have the same trigger do a copy of cells...
  12. H

    Data Segregation based on number of line items using different sheets

    I’m looking vba code in order to segregate the data as per below requirement. I have sheet1 which contains the data and required to copy this data till 90 line items including empty rows and needs to paste special in new sheet. This new sheet name should be changed to Setitem1 and it should...
  13. K

    Macro: copy and paste without blanks

    Hi all, I don't have much knowledge of VBA but am using research and help I can get from the web to create a tool. I am stuck at a stage and was wondering if anyone could help me. I have the following in sheet 1: <tbody> SKU NUMBER Supplier ISSUE RECEIPT DATE QUANTITY PURGE...
  14. M

    copy & paste (to and from) different worksheets based on the value of a cell for each row

    I have background sheets that make calculations based on input data that is found on each row of the main sheet. I created a ginormous macro that basically repeats the same command for a series of 30+ 'If/ If Else statements' where it finds the right background sheet for the row and then...
  15. The_Rock

    VBA - No Select or Activate

    Hi Folks I'm trying to delve deeper into VBA and am trying to run the following macro without resorting to 'Select' or 'Activate'. What I am trying is to get the macro to loop thru two different worksheets, enter a formula, then copy & paste it down to the length of the range. What happens is...
  16. C

    Copy/Paste Macro for columns-Need to match by Header

    Hi, I have this code that will copy/paste multiple columns between two spreadsheets, basically an "import". The issue is that the "Import" sheet will always be changing with more or less columns than the "Main" worksheet (which is the template). The code below just copy/pastes all columns. I...
  17. I

    Optimizing Slow VBA Code to Copy & Paste Formulas

    Hello - I am looking for any assistance someone can provide to help me optimize this slow VBA code. Processing 20,000 rows of data takes about 7 minutes. Basically I have four columns of data generated from formulas - 1 sumifs, 1 countifs, and 2 vlookup. I calc the first row and then want to...
  18. J

    Macro to copy table/range in excel to specifically defined word document

    Hi, I use an excel workbook that contains around 20-30 output tables/ranges and i would to have a macro which will enable me to open a specific word document and paste these tables/ranges from excel into the word document. I am unsure as to how to get excel and word to "talk to eachother"...
  19. F

    Loop through rows in an excel worksheet and copy a range if the cell isn't blank

    I am new to Excel VBA (using Excel 2007) and have been asked to create a macro to re-order a spreadsheet so that it will load into a new software package. The workbook is a download from our website cart which shows a list of all our orders. Here is a snapshot of the workbook (the workbook is...
  20. B

    VBA/ Macro Code that Copies area and Pastes in new sheet on next available row

    I'm making a program for a Photography company to help them keep track of theres invoices. On the Invoice sheet, after an invoice is completed, I want to select certain cells and have them posted in the Records sheet. I tried recording a basic macro but every time I run it, it replaces the...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top