copy & formula

  1. D

    Tabel doesn't copy formula in two rows when expanded

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

    VBA for copy data from one sheet to another

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

    Copy data from two different sheets

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

    VBA to copy formula range from a master sheet to all files in a user defined directory

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

    vba dragging formula left to right the number of columns stops based on a value

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

    If Function to Copy a different cell value into another cell and change different cell value

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

    populate column k with most recent populated cell

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

    Copy multiple rows and insert multiple times

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

    Copy the whole column if top cell equals certain text

    Hi all, I have two tabs in excel. One called Defects, the second called RawData. When i extract the data from a system, and copy it to the Raw Data, I want my first tab (Defects) search for where in the Raw Data the first row contains a specific text e.g. Issue Number then copy the...
  10. B

    VBA - copying down a specific cell value ?

    I need to add to the code below to also copy the value of cell 'Q3' down into each row each time the macro is enabled. Sub New_Risk() Dim varUserInput As Variant varUserInput = InputBox("Enter Row Number where you want to add a row:", _ "What Row?") If varUserInput = "" Then Exit Sub RowNum...
  11. M

    Copy Cell A in Cell C if a word is found in cell B

    Hi, I would like to find a formula than can do the following: Post in the current cell where I'm writing the formula (cell V5) the text contained in cell J5, if the text "Apple" is found in L5. I almost got it with this formula : =IF(L5="Apple",J5,"") but it didn't work because, event though...
  12. C

    Copying Cell-Value if target Cell is not empty - absolut beginner

    Hello MrExcel Community. I want to make a huge excel file, that so far needs multiple manual inputs of the same data, easier to use. Sadly formulae dont help anymore and I need to do it in VBA. Although - with my inexistent knowledge of programming - google helped me to answer most of my...
  13. E

    Condense Working Formula?

    The following code is ALOT... is there a way to simplify it? It was most likely recorded. I'm sure it slows down the Macro significantly... and it hurts my eyes :eeek::eeek: Rows("1:1").Select Selection.AutoFilter Columns("F:F").Select Selection.Cut Columns("E:E").Select...
  14. M

    Copy Paste Subtotal Row and Formula On Every Sheet Excluding Specific Sheets - HELP!

    So, I have a code that I have been working on now for 2 days and have hit a roadblock and not sure how to fix it. I am hoping one of you Guru's will simply look at it and see a line of code that is entered incorrectly or something. So here it is Sub Subtotals() Dim sht As Worksheet Dim subs...
  15. P

    Dragging formulas down column endlessly through a sheet

    Hi all, I'm having an issue with a worksheet. I created multiple formulas in different columns but i'm having issues getting it to auto copy to the next cell. i noticed that if you copy and paste info into cells that feed the formula it won't copy the formula down. sometimes through the column...
  16. A

    Copy Paste Formula of a range

    Please Consider Bold characters as Row and Column no <tbody> A1 B1 C1 D1 X (CELL A1) A1 X 24/04/2017 INDIA D2 24/04/2017(CELLB1) A2 Y 24/04/2018 CHINA D3 INDIA (CELLC1) A3 Z 24/04/2019 JAPAN D4 Y(CELLA2) A4 Q 24/04/2020 USA D5 24/04/2018(CELLB2) A5 W 24/04/2021 CANADA D6 CHINA...
  17. W

    Macro to copy range to new sheet everytime when the word "match" is found

    hi guys need a little help, i have a column (Column D) with a long list of rows containing the word "Match". i need all instances of "match" with a specific range copied to new worksheet example "Match" column d row 2 (d:2) I need E2:G9 copied to a new sheet along with every row that...
  18. K

    Copying formula's from one table to another!

    Whenever copying a formula such as =[@[Mar Fcast]] from one table to a new table with the same headings (obviously), the copy always changes to =Table1[@[Mar Fcast]]. Am I missing something that will allow me to copy a formula so that it only pulls exactly and doesn't attempt to reference the...
  19. M

    How to Copy Multiple Worksheets to a New File with Tables

    I have a workbook consisting of two sheets that I want to move into a different workbook. One is the front end worksheet, the other is for data validation, including several tables (which I need as tables to make the front end work). I tried simply selecting both of them and using the Move/Copy...
  20. M

    copying a formula from one workbook to another. Lost the will to live

    Evening peeps, I have been trying to figure out what is wrong with my code for the past 4 weeks and have got no closer to fixing it. basically the workbook that i have created is a way of me keeping track of the time that I work but from time to time I tweak the master workbook and then use a...

Watch MrExcel Video

This Week's Hot Topics

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