copyandpaste

Hi all, I am needing assistance with my code. I need the macro to go through files in a folder that contain vendor contact forms. I need to copy certain cells from each file (there are hundreds of files) and paste them into a master sheet. The fomats of the vendor contact files are different...

Hi all, I have some code which copies and pastes data from one workbook into another. It pulls data from the correct workbook, and then pastes into the other workbook (this is good). However, instead of pasting into column 'S' in the "data" sheet, it pastes into column 'S' in the "Status"...

Hi team, Wondering if it is possible to have a VBA to look in between blank rows and return specific cells in a copy paste function to another sheet. I essentially need a VBA that will search between blank rows and return specific cells and copy them to another sheet The paste format would be...

Hi All, Im having an issue with a simple cut and paste vba code which I have used previously. Im trying to copy from a range in one work book and paste values only into another. The problem Im having is, even after defining the workbook, sheet and cell location, Excel still asks me to hit...

Hi All, I'm still new to VBA but have since been experimenting with it for a piece of work I'm doing. I'm trying to add a row to the bottom of my table and have succeeded to an extent, however the formula it copies down when it adds the row becomes anchored using the "$" for some reason. The...

I have two workbooks with 3 tabs each. I want to collate data from above 2 workbooks into a single worksheet.The macro should copy header from only one sheet and rest worksheet data below it. The data count in each tab is not fixed whenever I am going to run the macro. Any help on how I can...

Hello i am trying to figure out how to paste a range of cells on to the next row when there are a few blanks in the row above. My code keeps overwriting them. Here is my code: Sub GetSheetstest() Dim Path As String Dim FileName As String Dim Sheet As Worksheet...

Hi, I am trying to write a macro sub that searches for a certain string in column X and copy the values in column I and K on the same row onto another workbook. Values from I will be copied to cell B15 in the new workbook, and values from K will be pasted to cell D15. The next matching values...