copy & formula

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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