paste

  1. N

    Copying and pasting a long row has issues

    Hi Wanted to see why I can't properly paste an entire row on cells like a few weeks worth from online excel to a die loaded excel file The copy part isn't the issue only the paste part And I think the message I get is The data your pasting isn't the sane size as your selection. Do you want...
  2. Agnarr

    VBA problem with creating new sheets

    Hello everyone! I have made a sort of registry crm where one enters product code and quantity, excel returns name of product and price*quantity, plus it calculates start and end registry, loses, gains and other stuff. Some macros that clear specific cells and 2 more macros that: 1. user enters a...
  3. A

    Copy/paste cell if Cell has it's a color Filled

    Hi Savvy People, I'm trying to write a macro which would automatically: Copy cells that have a fill color Paste those filled color cells (with contents, the color but not the number format) to a list on the same sheet- is different column or section Note: there multiple fill colors. Would...
  4. T

    Searching for data in column, if found Cut it paste on other sheet

    I want to search Column "b" for "98" and if found (could be multiples line) I want those lines to be cut and pasted in a new sheet called "Diesel Discount" This is what I got so far. If it Highlighs the first End With as error... Sub Move_Diesel_Discount() Dim LR As Long, i As Long With...
  5. R

    PowerPoint - Pasting text changes the language to "English (United States)"

    Hi all, I'm preparing a presentation and have written a lot in Word (with a couple of bits from ChatGPT). Whenever I paste the info into PowerPoint it changes the language of the text box from "English (United Kingdom)" to "English (United States)". This happens when I paste from anywhere...
  6. brendalpzm

    Copy worksheet into a new workbook

    Let's say I have 2 workbooks and i have to create 1 wb1 = workbook with the macro wb2 = worbook with the info so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook Idk if i explained...
  7. L

    VBA to find match of cell value on two different Spreadsheet and then copy adjacent cell (value and format)

    Hello, I have two spreadsheets named New.xlsx and Old.xlsx. I'm looking for a VBA code that compare each column T values (unique ID) in New.xlsx with values in column T (unique ID) in Old.xlsx. When there is a match, it then copy the value and cell format (e.g. cell color) of the cell in column...
  8. Y

    How do stop VBA pasting content under default signature in Outlook

    Hi all, I'm completely new to VBA but have managed to piece together a few things I found online, and mostly understand what it's doing. In order to copy specific cells from Excel and paste them into an Outlook email whilst retaining their appearance, I have the following code: Private Sub...
  9. brendalpzm

    Copy data from a range and paste it in the next available row in another sheet

    I have a range ("A31:AB31") in the "Input incidents" sheet, so I need to paste it (only values, no formulas) at the next available row in a data base ("Incidents_Accu"), the columns are also A:AB in the data base, the information should be accumulated in the data base by clicking on an ActiveX...
  10. P

    Type Mismatch when defining workbooks

    Hello! I am probably doing something wrong but I keep getting an error and I dont know how to fix it. The long and the short of it is I have to copy data between three different excel workbooks Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook ' Set wb1 = ActiveWorkbook Set wb2 =...
  11. D

    Trying to make a form that will auto update values on different sheet

    I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...
  12. Agnarr

    Type a code in a cell and have it replaced with a given name.

    Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). I have an excel where I need to type a 4 digit code in a cell and when after pressing enter, I need it to be replaced by a name corresponding...
  13. M

    I would like to make a macro that loops down a pivot table slicer list and create separate sheets based on data from each slicer selection.

    So I have a sheet that has a pivot table in the "Pivot Table Reference" tab, that has a slicer called reviewee name. Based on what is selected on that slicer that pivot table is referenced in a sheet on the "Output Sheet" tab. What I need is some kind of a VBA cycle code that can automatically...
  14. J

    VBA Copy/Paste

    I'm looking to copy/paste within the same macro, using 2 different methods, ActiveSheet.Paste and Selection.PasteSpecial. Scenario: Row 1 has a series of cells that I'd like to duplicate to rows 2, 3, 4, etc. However some cells (call it A1) has a formula in it that I'd like to only copy the...
  15. J

    Copy Multiple Ranges Paste to Designated Ranges

    Copy ranges Accounting!: AY13:BH13 AL15:BH15 Paste(Special) ranges InvPrint!: AT6:AY6 D20:AJ20 This is as far as I got regarding the code... Dim Rng1 As String Dim Rng2 As String Dim Rng11 As Sting Dim Rng22 As String Rng1 = Range("Accounting!AL15:BH15") Rng2 = Range("Accounting!AY13:BH13")...
  16. B

    Copy and paste x times with a y Size

    Hello im trying to copy and paste a variable number of columns a variable number of times. I can get it to resize a variable amount of times but not if i want to do a variable amount of rows as well. this is my code: Sub getRng() Dim Cval As Variant Dim Rng1 As Range Cval =...
  17. U

    Copy Paste Formula adding extra rows

    Hi there I have a sheet "invoice template" which contains 6 rows per 'invoice'. Each invoice pulls the reference and the container number from the second sheet ("jobs") This works in the first 6 rows reference is =jobs!A2,and container is =jobs!B2 However when I copy those 6 rows in...
  18. E

    Paste HTML table into one cell (overflow in cells below it)

    Hi excel gurus, I have an interesting use case, I am attempting to paste HTML table code into a single cell, however it appears to only paste a certain amount of information (assuming there's likely a max character limit for a single cell) With the above in mind, is it somehow possible to paste...
  19. Chris_010101

    Paste Values in VBA

    Hi All, The following code moves data to an archive sheet, based on the value selected from a list in column P. It also looks to see if filters have been applied and ensures the data is moved to the next available row, regardless of filtered data. It works perfectly, however, I'd like the...
  20. M

    Copy and paste to blank cells only

    Hi, Have a peculiar problem in excel that I am trying to solve. I have data in an excel sheet under columns A through E (including column headers). I want to paste this data in another excel sheet. However, while pasting, I want to past the data only if associated cell in other sheet is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top