destrow

I can't figure out how to edit this code to paste values. I've search so many forums. Can anyone help? Sub SUBMIT() ' ' SUBMIT Macro ' ' Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As Long Set ws1 = Sheets("Entry Form") Set ws2 = Sheets("Reconcile") DestRow =...

Hello, I use this macro to copy and Paste from WS1 to WS2. But I need it to copy and paste new data on the next row down on Ws2 When the button is selected. I cant figure this out. Thanks for all help provided. Sub ButtonCode() Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As...

I have written code to open a workbook and copy data from A2 onwards on sheet5 on the source data to H2 on the destination sheet when running the macro the data from A2 onwards on the source data (Sheet5) on not being copied I also need to the macro to allow must to select another file or...

Hi all, Not that great on Excel so looking for some help please. I have the below VBA that will transfer data from certain cells on Worksheet 1 to different cells on Worksheet 2. It is copying the formulas in these cells where I need it to copy just the values. Sub DataTransfer() Dim...

I have code written and placed in Worksheet Change which allows the user to put in time without colon's and displays the time as 05:00, 16:00 etc. The code works great. Here is what I am using: If Intersect(Target, Range("D2:D77, I2:I77")) Is Nothing Then Exit Sub On Error GoTo...