copy & paste cell

I have multiple csv/xls files that i want to browse from user form then get specific cells data from them and copy to specific cells of already present workbook with formulas which want to browse again from user form and get output to a folder. I have multiple batch of 4 files in which i...

I need to make a macro/write a VBA code to select from a range of cells, say H8:AQ117, all cell values greater than 1, and then copy and paste them (paste Value only) at the same location without their formula as I want those particular cells to remain unaltered as I change the values at their...

I need a way to copy the value of multi cells that pertain to a specific list of 3 digit numbers that can either be paste to a new worksheet or paste to a column as a long list on the same sheet doesn't matter to me.. example colum a has a list of 3 digit codes 555 ,444,333, etc next to the...

I have been trying to copy comments over using VBA and every time I do it will work until I open the excel file again and then it crashes. I don't know that it is a problem with the code but perhaps how the pictures are viewed. I have them as comments with the background being pictures...

I have the following code which works well but i now need to copy J & K if the condition is met I have tried a couple of ways but cant get it to work so use same module but for J it would be much quicker if i could do them both together as there are often about 4-500,000 lines of data but on...

Hi all, I created a workbook with 7 sheets (a master and one for each person on my team). The sheet is meant to track our commissions. I used a VLook Up Formual to match the product with the commission rate (the table is on sheet 2). Everything works on the master sheet. However, I also put in...

Hello :) I've learned a little bit from you all to at least try and start my own code, but I'm completely lost this time. I have a folder with about 120 text files in there. In a header-named column of each text file there are numerical values. I'm trying to create some code that will open...