selection.copy

Hi all, This might be a silly question but i am new at VBA so can't seem to figure out what the error in my code it. I have two sheets, sht1 and sht2, from which a user is to highlight the row to transfer sht2 from the next empty row and starting from column C. My code is as follows Sub...

Hi, Please check the following macro code and advice how can we run it in loop, Sub Loop() ' ' Loop Macro ' Range("D2:D8").Select Selection.Copy Range("E8").Select ActiveSheet.Paste Application.CutCopyMode = False Range("F2:F8").Select Selection.Copy...

Hello, I am trying to automate some data importing into a spreadsheet from another then save as a new file name. When I go through the macro it all works right up to the point it trys to save the spreadsheet. I just get the run time error 424: Object required I am sure I must be missing...

Hi! I need to Filter An array of data by a criteria(emails), then the filtered results has to be pasted in other sheet, at a specific row(the row corresponding to each email address), but if there are two or many rows that has to be pasted, excel has to add the additional rows in the sheet. I...

Hi All, i have written a code that looks quite repetitive and could probably be structured much easier with a loop / case, however i'm struggling to apply a proper form. I've highlighted the only difference in bold. Could you kindly have a look at my code below (it's an extract, the code...

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

Hello, I believe I am looking for a very simple VBA code but am not sure because of how my current Macro is structured. During one point while my macro is running it checks a certain cell (B16) and if it is blank it will issue a message, "No Results" and will end sub. If there is results it...

Hello, I have the below code that used to run fine but now it seems to be getting hung up and excel now freezes and the macro does not complete. Any idea what could be causing this? Thank you Application.ScreenUpdating = False Application.Calculation = xlCalculationManual...

I used to have this working but then we made changes. Can you help me? this macro opens up and pastes each sheet into one sheet. Sub Aisles() ' ' Aisles Macro ' ' ActiveWindow.ScrollRow = 50 ActiveWindow.ScrollRow = 48 ActiveWindow.ScrollRow = 46 ActiveWindow.ScrollRow = 43...

Thanks in advance, i have the following VBA code, Its o.k. no change required Range("IX10").Select ActiveCell.FormulaR1C1 = _ "=IF(AND(RC[-253]=""Na"",R[1]C[-253]=""Yes""),COUNTIF(R2C[-253]:RC[-253],""Na"")-SUM(R1C:R[-1]C),"""")" Range("IX10").Select Selection.Copy...

Hi ive recorded a macro to transpose a cell contain text and then use in a validation. The code works fine but is really messy and i would just like to tidy it up. Wonder if there is any other code that would be more beneficial. Thanks in advance MC Code: Sub Macro3() ' ' Macro3 Macro ' '...

Hello, I have the macro below. I have fill down in two columns but for some reason, it is not filling down to last row. It stops at row 71 even though there are 94 rows of data. The # of rows vary week to week so the last row # can't be static. I have pasted the macro below. I am having...

Hello, I need to write the VBA code make this easy. Range of A1:AN81 will put into or copy at the Range A+81. They are in the same folder. Thanks in advance. Please see the code below. Sub CopyPasteMultipleWorkbooks() Workbooks.Open Filename:= _ "G:\My Drive\2018-2019 SF1\Grade...

Hello everybody. I am wet behind the ears with VBA/macro's in excel. I have a spreadsheet that I use to input information, but I want to copy specific rows from that "active" sheet to other sheets based on the values in the cells of colume"b". The rows will be copied to different sheets based...

Hello All, I'm copying information from a table on the server and pasting the data onto another workbook. The problem is the table is always being filtered so when the macro runs it pastes the visible data only and not the entire table. Any help would be appreciated, thank you in advance, -E...

I have a followup question to an earlier post. The formulas are all working great. However, I need for the coding to overlook 3 customers when selecting the "Top 5 Customers". These customers are GMIT, BGS GRM, and GMIT SC. I'm not sure how to incorporate this into what I have currently...

Afternoon All, I have the following Macro for the sample Table below. I would like the Macro to loop until it reaches the end of the table, at the moment i have the shortcut entered at the end but this requires me to be infront of the computer at all times to end the macro by pressing ESC...

Hi, I have a probably very frightening piece of code below. It does the trick but is clunky I know. I just don't have the know how to streamline. Its a very simple request I'm sure... Copy columns from one sheet based on table headers in to another based on table headers (they are the same...

Dim lastRow As Long destrow = Sheets("Master Wheel").Range("A" & Rows.Count).End(xlUp).Row Columns("T:T").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("T2").Select ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(VLOOKUP(RC[-19],'Master...

Hi all, I have the code below that works as needed, but I'm looking at enhancing it further. I want run the code below, and then have cell F5 increase by 1 and then rerun the code below. I want to do this until F5 hits 40. Appreciate any help and assistance. Range("P8").Select...