copy and paste cell value

Hi, I have the following code. What it does is that it automatically adds a new row when some conditions are fullfilled. This works good, but I am having problem with the next step, which is to copy and paste the value in "D35" To the new created row in column "AB". As you can see below, after...

I have a worksheet that has 3 columns of numbers, each column having 26 rows (H2:H26, L2:L26 and P2:P26) and on the same worksheet a matrix which is 4 x 15 (4 cells in adjoining columns and 15 rows down B3:E17). I would like a macro that would upon clicking a button, or clicking or doubleclick...

Hi, Im currently looking to to create a macro that will pull together entries from multiple worksheets and paste them into a single table on my main worksheets. This involves matching the names in column A to the names on worksheets for each month and matching the correct monthly value based on...

Hi Gurus, I have been facing a problem that I am unable to solve by myself. I am copying and pasting a few worksheets from a SharePoint site into a local file. Some of the worksheets are lists so I have to differentiate among them. Nonetheless Excel will not allow me to paste in the local...

I have been using the below macro to export worksheets without macros/formulas, now I am looking to export the whole workbook without formulas and macros. Export it as a "flattened" workbook. Sub Flatten() Dim wbDest As WorkbookDim wbSource As Workbook Dim sht As Object Dim strSavePath As...

I am having an issue getting my value I copied to paste in to my autofilter. I have created a loop that will work down a list , copy the next value, past that value in an autofilter on a new sheet, copy the results found, and paste the section to the original sheet. The code will work down the...