copypaste special

Hi, I am new into de forum and kind of new into VBA. I have written this code(with some support of youtube videos etc) to copy a specific Sheet from one worksheet to another. Sub CopytoWorkbook() Dim x As Workbook, y As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim LastRow As Long Dim...

Hi folks, I am a bit syuck on the auto-filter syntax. can anyone tell me how to change this so that I am not copying and pasting the whole row, but only copying range "A" to "L" to usdrws and pasting into range "B" to "M", (same rows as below). ws.AutoFilter.Range.Offset(1).EntireRow.Copy...

Hi all, Any help would be greatly appreciated. I have a spreadsheet I use to document tasks, I use column B to give each task (row) a numeric number which only appears should I have a task heading entered in the adjacent column C row. I use as if formula in column B. Ideally I would like to...

Hi everyone. I am really new to Excel VBA and I am trying to automate some processes at work. Before we push out our products, I use workbook A (Source & the active workbook) to generate charts based on bloomberg data and given parameters which are keyed in. These parameters are keyed into...

I'm just learning to improve my VBA skills. Made lots of progress yesterday but now I find myself faced with a momentary wall... My dilema: I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000. There is a drop-down menu in Sheet 1 containing a list...

Excel Genius's. Need some help with vb code to copy and paste special (values only) from one workbook to another. Workbook locations are on my desktop for now, however I plan on filing them on server drive later. Here is what I need to accomplish: Copy cell values (D4, D6, J4, L4, L6, & range...