copy & formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. D

    Macro to Paste cell based on next cell selected

    Hi, I am a very basic user of VBA and was wondering if anyone with a little more experience might be able to help me with a solution to a problem that I have. I have a function that I need to create a macro for that does the following; 1. Click on a cell in worksheet 'A' 2. Automatically...
  14. O

    Macro?: Copy & Paste from Two Lists

    Greetings. I have two sets of data in the Sample below. I am looking for a way to automatically create the Outcome: each value in Column A paired with each value in Column B - creating two new datasets in Columns C and D. The solution must work for much larger datasets. THANK YOU!! Sample...
  15. G

    Excel Macro - How to make whole column always Today's date

    Hi All, Background - I have 2 Excel Files A and B I manually copy all data from File A to B exact copy. I am Reading from File B only ( dont ask why not read from A as its a process) B After I copy the data to File I Read Line by line to a Sessions Screen to do that I need to make all...
  16. S

    Excel need to copy, alt tab to IE then paste and alt tab back, then move down and copy again.

    Hello im trying to populate an IE page with an excel macro, by copying a cell value, alt tabbing to the IE page, pasting the value in the IE, then alt tabbing back to the excel, and moving down one and repeating this function over again. so far i have this code that doesnt work on the IE page...
  17. S

    how to do a copy from a series cells

    Hi guys, I have a long list at column A, and I want to do a copy in column B for two or three of each. how do I use a formula to do that? thanks. A john mike phil paul ...... B john john mike mike phil phil paul paul ......

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top