copyrange

Greetings of day, I have macro which work for single condition but all time I have to change condition as multiple condition which is not feasible any help to modify same current macro as follow Sub CopyDataToNewSheet() Dim sourceSheet As Worksheet Dim destinationSheet As Worksheet...

Copy ranges Accounting!: AY13:BH13 AL15:BH15 Paste(Special) ranges InvPrint!: AT6:AY6 D20:AJ20 This is as far as I got regarding the code... Dim Rng1 As String Dim Rng2 As String Dim Rng11 As Sting Dim Rng22 As String Rng1 = Range("Accounting!AL15:BH15") Rng2 = Range("Accounting!AY13:BH13")...

Hi, I have a VBA that works perfect moving selected data from column A to a new sheet. I want to use this VBA in a new workbook, but the data I want is in column X and I can't figure out how to change it to X. So in the source sheet(BRO_20190910) if column X contains the word ECO, I want to move...

I have some code that is moving data from a 'raw data' sheet to another sheet, but on the new sheet it is not moving the data with trailing zero's. How can I update this code to make sure it move all the raw data over as it is shown, I think I need to move it as Text, but I'm not fully sure how...

Hey Everyone, I have been trying to figure out how to make a button that will copy specific rows (A6:L6 and down) from "Optimization Ticket". This sheet could have 5 rows filled in or 50 rows filled in. These rows will land in "Process Ticket" starting at cell A2. This is what I have so...