copy/paste

Hello, Hoping for some help. I have a list of tasks pulled from ADO and I want to copy data from the list based on name and paste in sections in the same sheet based on name. I am familiar with how to scan data based on string, but not sure how to scan for location to paste below based on...

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

Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?

Good Afternoon, All. I have a workbook, CallLog, containing the following tabs--"Summary,"Data","MysteryCallLog2," and "Pivot." "Pivot" is merely derived from "Data," and used to visualize data in graphs and slicers on "Summary." "Data" contains the resulting information from a SharePoint...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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