copy/paste

  1. C

    What's the most efficient way to remove all the salary info from my model without ruining all the calcs?

    I work in Finance and I need to send out our budget model to one of our business partners, but she can't see all the salary info we have in there. One option is to go tab by tab (there are probably 30) and manually copy/paste values in the person-by-person salary calc, then delete the person by...
  2. A

    Copy/Paste and remove duplicates

    Hi all I have done a macro to copy data from sheet2 to sheet 3 then remove duplicates, however it doesn't work, please could anyone help? Sub Reconcile() Dim LastRow AsLong LastRow =Range("A" & Rows.Count).End(xlUp).Row Sheet2.Select Range("F2:F" & LastRow).Select...
  3. P

    Copy/Paste from one workbook to another 2 workbooks with range

    Hi please can you help me I have a command button in Book17 where once clicked I want to copy range A1:E2 and paste into 2 other workbooks which are Book16 and Book18, I have the code below but it doesn't seem to work and the lines come up in red, please can you help me? [CODE]Private Sub...
  4. S

    [VBA] Copy/Paste Values to New Workbook and Separate Tabs

    So I have somewhat of a complex requirement that I need some help with in VBA. I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook...
  5. B

    VBA macro will copy/paste if conditions are met

    I have a VBA question on how to create a macro that will copy/paste names to specific worksheets if conditions are met. A few examples below of how the code should run through the sheet... B12 is Yes. Include is 1. Exclude is 0. Therefore, copy/paste NameG1 to cell A1 of Name_Inc_1. Save...
  6. B

    VBA Macro will copy/paste names to sheets

    Hello everyone! I have a VBA question on how to create a macro that will copy/paste names to specific worksheets if conditions are met. I get new data each month so this will be very helpful for me if it's automated. The data is 91 rows (90 reports) so this is just an example. The idea is that...
  7. S

    Efficient way to convert percent to number

    Columns D-J contain values currently in the percent format. Changing format to number, updates it to .08 for instance. I know I can multiply by 100 in another cell, then copy/paste... but is there a better way to accomplish this? Tia
  8. H

    Worksheet Change Event when pasting multiple rows/columns

    I'm trying to have code run when data is pasted into a worksheet. I have this code on the Sheet page, but it doesn't work if the data is pasted. I have to go specifically to only A1, and copy/paste. Thanks. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1"...
  9. Johnny Thunder

    VBA Help - Defining 2nd Open Excel Workbook without knowing File Name - Excel 2016

    Hello All, I have come across a project that I am not sure how to finish, here is the request details. Have a macro in File A to copy details from a daily/weekly run query with a changing file name. So essentially, Macro is in File A, and query is in File B. I need a way to Dim File B as a...
  10. L

    VBA unable to copy and paste with selectionChange &unlocking/locking worksheet

    Hi Everyone, I am having problems copy from a different workbook into my current workbook. I can copy but i can't paste even within the same workbook. I've isolated down to my coding with Private Sub Worksheet_SelectionChange(ByVal Target As Range). I suspect it has something with me unlocking...
  11. Johnny Thunder

    VBA Help - Copy/Paste 3 Blocks of Data using LastRow - MS Excel 2016

    Hello, I am working on a project that requires 3 blocks of data (1 Column) one after the other. I thought I could use the LastRow Syntax to get this done but it seems to not be updating after I paste the first block on my spreadhseet. My code so far with comments is below. Any help is...
  12. I

    Copy/Paste Section Values with Offset

    Hello, I am looking for recommendations to speed up a macro. The below macro copies a lot of formulas located in A2:R43, pastes the selection every 47 rows, then pastes the new values of the formulas over the previous paste. 'Copy/Pastes A2:R43 the number of times equaling A1's value For...
  13. M

    VBA to sum

    Hi Guys, I have 10 product, in value C3 when I put 1, macro caluclate & copy/paste some values for product 1, when put 2 in C3 macro calculate & copy/paste some values for product 1 and for product 2, when 1 put 3 in C3 macro calculate & copy/paste some values for product 1 and for product 2...
  14. X

    Searching in the range

    Hello- The .Find function does not work if the range (myRange) contains formulae. But it works, when I copy/paste values in the range. Please suggest how I can make it work without copy/paste set findText= .Range("myRange").Find(What:=myText, lookat:=xlWhole, MatchCase:=False...
  15. Johnny Thunder

    VBA Help - Copy/Paste Not Bringing over Formats????

    Hi guys, have an issue that is giving me a headache. I have 25 .xls files (formatted for 97-2003 Worksheet). All the files are the same and have the same data in them. The only difference of the files is a few Headers of Territory names (i.e contry names). I have a macro on a seperate .xlsm...
  16. D

    VBA Copy/Paste is sometimes pasting the wrong/previous value

    My problem is that 'sometimes' the code in the Copy/Paste section is not pasting the correct value. I have multiple versions of this code attached to buttons that sets up the workbook different ways for different people, first doing all the filtering with the slicer caches, then copy/paste the...
  17. Johnny Thunder

    VBA Question - Deselect after Paste - Excel 2010

    Hi guys, Stuck on a problem with my code, I am creating a new sheet and then doing a copy paste function to get the data onto my newly created workbook/Sheet but for some reasons I can't deselect the pasted cells. Maybe someone can see a problem or a solution for my issue. My code: With...
  18. K

    Copying data in columns

    Hello. I am looking for VBA code to copy data from a column in Excel to another column (to the right) on the same worksheet. Trick is if the destination column has data in it, I need to go to the next column to the right that does NOT have data. In my example, I have data in range C4:C25. I...
  19. I

    Copy/Paste Formula -> Value Loop

    Hello, First time poster, long time listener. I'm am looking to do the below: 1) Formulas located in A2:S43 2) Copy/Paste those formulas in row 46 (leaving row 44 & 45 blank) 3) Copy A46:S87 (just pasted box), and paste the values and formatting into itself (A46:S87) 4) Loop 1-3 times the...
  20. M

    Copy/Paste in value within 'With/Next'

    Hello, I am building a macro, I am in a section with a With / Next Loop. I need to copy/paste in every loop the content of cell B3 because there is currently a vlookup formula where I bring data to excel. Thus, I need to copy/paste in value that cell. Could you please help me with the code? I...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top