pasted

  1. 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"...
  2. J

    VBA macro - posting over last cell with blank value

    I have an almost perfectly functioning macro which matches rows in one table to another, and then imports any rows that aren't present in the source table onto the end of the destination table. The ONLY problem i'm having, is that one section of the very last row that gets pasted gets...
  3. D

    Using PowerQuery to import JSON?

    I've never used 365's PowerQuery before, but I'm told that it can handle exactly these kinds of requests. Here's a static Yahoo URL with all the stock option data for symbol AAPL: https://query1.finance.yahoo.com/v7/finance/options/AAPL But not sure where to go from here; following online...
  4. A

    Removing Shapes Pasted during Copy / Paste operation

    I have copied a range of rows and pasted them onto the same worksheet. I have 4 macro assigned shapes that are also copied as part of the copy and paste operation. How can I avoid repating these shapes on the worksheet, ie not copy them, not paste them or remove them once pasted?
  5. N

    Suggestions on a to-do list

    I amhoping to get some suggestions for what I am trying to accomplish. I amcreating a worksheet for all users in my department. I am looking to create ato-do list section in my worksheet that will include a list of tasks that willbe copied from a website. The user will copy data from this...
  6. F

    VBA to load data from userform to next available row

    problem - require vba when commandbutton click in userform1 goto sheet "log" for spare row textbox1.text to be pasted to column A textbox2.text to be pasted to column B textbox3.text to be copied to column c next time userform loaded and command button clicked next spare row same as above...
  7. S

    VBA - Copying and Pasting multiple ranges

    Hey all, I've got another slight query: I have this code: Sub Copy() Application.ScreenUpdating = False Dim wkbSource AsWorkbook, wsDest As Worksheet Set wsDest =ThisWorkbook.Sheets("SMART Raw Data") Dim lColumn AsLong lColumn = 3 Const strPath AsString =...
  8. G

    Increasing by different percentages, formula that can be copied

    Hello! I'm in search of a formula that can be copied and pasted (or pasted special) for increasing a number by different percentages (10%, 20%, 30%, etc). I know how to do it if I type out the formula in each cell, but I need a shortcut. Here's an example: Suppose the number 10 is in A1. I want...
  9. S

    Macro to Copy, Paste & Filter into a different worksheet

    Hey all, Hopefully someone will be able to help! I have digits ranging from 0 - 100 in K4:K60 in a worksheet called ‘Raw Data’. There is also written contents in B4:B60 and C4:C60 in the same worksheet (Raw Data). What I am trying to do is identify any digits in Column K that are under 60 and...
  10. I

    Pasting a value into a cell losses formula

    Hi, I run the code below. Private Sub CommandButton1_Click()Sheets("INCOME1").Range("C30:F30").Copy Sheets("INCOME2").Range("C4:F4").PasteSpecial Paste:=xlPasteValues Sheets("INCOME2").Activate ActiveSheet.Range("A5").Select Sheets("INCOME1").Activate ActiveSheet.Range("H32").Select...
  11. L

    Data validation not detecting pasted data

    in the Data Validation check for duplicates (using countif(range,cell) formula) - it is detecting KEY IN entry BUT NOT copy pasted data. Is there a way for Data validation to capture also the copy pasted data? many thanks
  12. A

    VBA Copy/Paste Error

    Hi all, I have a macro that runs some calculations and then copies results to another file. However, I'm getting a 438 run-time error stating "Object doesn't support this property or method". Set dbWB = Workbooks.Open(DBFile) Set dbSh1 = dbWB.Sheets("DB_Ready")...
  13. R

    Copy Paste : Loop Until

    Dear all, Wanted to understand the Loop Until in Copy & Paste. Example: Data are available in Sheet1. Column A There are numbers available in various cells - Some are filled in and some are blank. Requirement is to copy 1st filled in cell in column A and then paste it below in all blank...
  14. D

    A Macro to Fill data from Master table to individual sheet

    <tbody> Cus_Code(Column A) Name (Column B) TIN (Column C) VAT (Column D) Rs.(Column E) BBE ABC Perra 104074472 SVAT001084 2550 Row1 BTE D. KAMAL 114169161 SVAT000585 3256 Row2 DSL L.SUNIL 114337617 103256 2456 Row3 ELS F.SILVA 114089087 SVAT000550 11000...
  15. M

    VBA loop that moves data based on conditions

    Hello everyone, I look for a code that can help me to set up a report and move the data based on conditions: IF the first data string is different from 2018 in Column A and/or B that string of data should be cut and pasted in the last column above that very line. So every time the expression...
  16. M

    VBA loop that finds a text string, delete a range and setup a clean dataset

    Hello everyone, I am not familiar with VBA but I look for a code that can help me to set up a report. Basically, the code should find the word "Conf" and delete the range including the row containing the text string and 6 rows below etc..in a loop Range("A2").Select...
  17. K

    Is it possible to organize a paste to different rows?

    Simple question but I don't know if it can be done. Imagine you have basic data to paste in column A1-A4 but it needs to be pasted every 3 rows. Normal paste would just be A1, A2, A3, A4 after a copy paste What I'm looking to do, I would grab the data and after I pasted, it would show up...
  18. M

    Delete Unselected Rows of a Table

    Hi all, I've been referencing this thread: https://www.mrexcel.com/forum/excel-...cted-rows.html Specifically, this formula: Sub KeepSelectedRows() With Selection OnErrorResumeNext Rows("1:" & .Row - 1).Delete Rows(.Row + .Rows.Count & ":" & Rows.Count).Delete OnErrorGoTo 0...
  19. G

    Copy and Paste Between Two Workbooks

    I have 6 files saved on a local drive (in a folder called Automobiles) and would want them to be added to a master workbook (master_file) in their specific worksheet. Each file has its own worksheet and I would want to copy everything from row 2 to the last row from the files and paste them into...
  20. K

    Excel 2010 vs Excel 2016 (365)

    Hi My formulas, especially the more complex ones, works in my Excel 2010 at home but gives an error message in 2016 at work!? Even when copied and pasted from 2010 to 2016. Annoying! Any help will be much appreciated.

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