copy & formula

I am writing a reusable VBA routine to copy data and formulas from one Excel workbook to another. I am working with large amounts of data and formulas and have found that copying by assigning values (Range2.Value2 = Range1.Value2 vs. Cut/Paste) has better performance. However, I can't figure out...

I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

Hey guys, As the title says, i have two sheets named A and B. I import excel data from a report into sheet A with columns going from a - z, what i am trying to do is set up a formula or macro on sheet B that will automatically fill data from specific columns in sheet A to sheet B. IE Sheet A...

Hi guys I have a problem, you might be able to help me with. I have two workbooks. I am able to create a macro, which allow me to copy a range(table) from workbook1 and insert it in workbook2. My code is very simple (just an example) workbook1.sheet1.range("xxx").copy...

Im trying to copy down a formula down in VBA using the following code. Sub offsetConcatenate() ' This will add the concatenate formula Dim row As Integer Dim DateCountCalculator As Integer Dim MinusStart As String DateCountCalculator = Range("DateCountCalculator").Value For row =...

I have a worksheet that I need to copy cells in row 7 but I only the information from every 7th column for now. For example, the first few cells I need to copy are C7.J7,Q7. This file goes on for years worth of data. I tried =OFFSET(C7,0,7) which worked for the following cell but when I drag it...

Hello I tried to use this code to copy all the data from the column P6:P (last line) from the sheet "Original" and paste it on another sheet called "Test", well actually those data from the sheet "Original" are values, which are sums values by using FormulaR1C1. When I copy that on the sheet...

hi i am trying to copy values from sheet to another. in the data sheet i gave numbers from F5, F6 and so on. and in the destination sheet need the data in M24, M34, M44 and so on. i was doing it by =F5 in M24, but i have 700 values to be copied every day and it wll take a long time. if any...

Can my code be less glitchy when it’s coping data from one tab to another? When i select input from tab 2 it flickers between tab 1 & 2. How can it be smoother? Sub CopySource() Dim wsData As Worksheet Dim iRow As Long Set wsData = Sheets("Input") Set wsT = Sheets("Tracker") Set work =...

Good evening I have a sheet whereby there is a dynamic column A and B with dates that populate (as time goes on, more dates appear etc.). In the worksheet, there is some formulas in cells C:ZZ which use the data in Column A as an XLOOKUP. The formulas in the worksheet don't auto populate the...

Hi Gods of Excel, how are you ? ? Guys, I took this formula from one place and try it works perfect. It can copy files from one folder to another, but I want to update it and add color in cells which were copied something as indicator ( fore example green color). Is it possible ? Example...

Hello everyone. I have an Excel-sheet with a table, in which, I weekly insert new data and thereby expand the table. A minor issue has annoyed me however; I have some prewritten formulas in many of the columns in the table and once I insert new data in empty columns within the table...

Hi, I have the below data in "sheet1" Provider Number Of Tasks Number of OLA Fulfilled Priority OLA Fulfilled % Pbonk 2 1 Prio 2 50% Fiscal 3 0 Prio 2 0% Pbonk 12 7 Prio 1 58% Fiscal 1 0 Prio 1 0% Fiscal 10 3 Prio 3 30% Pbonk 82 59 Prio 1 72% Fiscal 14 1 Prio 1 7% Pbonk 87 23...

Hello Everyone, I have two sheets with follow data: Sheet 1 SR. No Data 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Sheet 2 SL. No Data 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800 I am looking for a formula/way to copy data from above sheets to a third...

Hi! I am trying to copy a formula from range A1:H2 in sheet 1 of my master workbook and paste it into the range C1:J2 of the first sheet in all .xls files in a user-defined directory. The .xls files are all uniquely named and have unique sheet names. Thanks in advance for your help!! This is...

I am attempting to reduce the amount of formulas in my workbook. So I only want to copy enough formula for the individual sheet. I have a cell A1 that contains a number, what I want to do is copy/drag the formula in B2 to the right by the number held in A1. ie if A1 = 12, then it would copy/drag...

Hello, My first post because I usually find my answers without asking :) So here's my issue: I'm trying to create a formula, using IF Function maybe??, that copies certain cells from one sheet to different cells in another sheet and change a cell value on the first sheet, but the cells are...

I have been racking my brain and google for a few days now and cannot figure this out. Column K is sparsely populated and I cannot figure out a formula to copy down the data from the most recently populated cell in that column whenever the adjacent cell in column L is populated. can anyone...

Hi Everyone Probably about a month or 2 ago I was able to copy a few rows and insert them on my desired location multiple times. Does anyone know if this was just an update or a tick under some or another setting? The rows copies has formulas in them thus the clipboard would not work for this...