pasted

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"...

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...

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...

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?

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...

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...

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 =...

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...

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...

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...

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

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")...

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...

<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...

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...

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...

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...

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...

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...

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.