copy & paste

I need help creating a macro that goes through each file in a folder and copies distinct cells in each file (all the files have the same formatting). Then I need to paste each cell into a master sheet that contains merged cells that are different sizes (as shown in the picture attached). With...

Hi i am trying to see if there is a way to copy data from one workbook to anther with the user being able to select the file to grab from and the sheet is sheet 1 and the only sheet in that workbook. The range of the data to look and grab from is from A3 to the last used row in column A but goes...

So, it's not a huge thing but just trying to create a button that just grabs non-blank rows of data and throws it into your clipboard for pasting into another spreadsheet or somewhere else. You know pdfs and such don't always copy very well so the data doesn't go nicely into Excel. I'll just use...

Hi all, I need to copy data from workbooks all contained in a folder called "Cycle Data" into a master sheet. From each of these sheets I need cells H66 and Q66 to be copied and pasted into a table that contains merged cells. I also need the name of the worksheet to be carried over with the...

My workbook contains several worksheets. I have code that copies and pastes conditionally formatted data between sheets. The data transfers fine but I can't get the formats to copy over correctly. I have tried different paste commands with no luck. Below is one example. Any suggestions as...

Hey y'all! I have a software that generates excel spreadsheets using a pre-determined template. I merge them into one workbook using a macro that then renames the sheet based on on the sheet's B2 cell value. I currently have indirect formulas on a summary sheet that can pull data from each of...

Hey. I've come across the common problem that is 'I know what I want to do but I don't know the proper term for searching'. For this problem I have two sheets ("Source" and "Destination"), and a Command button to copy and paste. The source data is F4:F198 on sheet "Source". I want it...

Thanks for any help , it is needed, i have searched and tried to find some code to make my own but have no luck so i am looking to this forum yet again for help. So what i am looking to do is to simply copy values of a cell and paste the value in another cell on a separate work sheet using...

Hi all, So I read some topics on Google to solve this issue, but couldn't got it working. Also I am still quite new with VBA and only know the basics, but eager to learn more about VBA. My case is as follows: We are making exports with around 250 columns of data, some of the columns are...

I'm looking to copy/paste within the same macro, using 2 different methods, ActiveSheet.Paste and Selection.PasteSpecial. Scenario: Row 1 has a series of cells that I'd like to duplicate to rows 2, 3, 4, etc. However some cells (call it A1) has a formula in it that I'd like to only copy the...

I hope that someone can help me with the following problem. I have a workbook with different sheets and tables. A commandbutton copies a ListedRow to another table. I created a small workbook that explains my problem. The code that copies the full ListedRow works perfect. Based upon a "yes" in...

Happy holidays! And thank you in advance! In summary: I need a macro that would copy all the columns A:C starting from Row 2 if the sheet name is "Apply" or "apply", of all the excels in a specific folder. I need to paste all these values on another Excel. Example: Specific folder(changes...

Hi all , I am trying to copy part of an element text and paste it in another element ,in its search box. The element contains a a policy number that i need to check in another system and it looks like this 60.22.9591 / RANDOM VENDOR NAME I need to get the numbers before the "/" and remove the...

Hey Guys, i have an Workbook with 5 Sheets where you can add Data while Using a Userform. The Data begins in each Sheet in row 10, since i nead the rows above 10 for my interface. I have also an Mastersheet, where the Data from these specific Sheets should be copied and should be edited if...

Hi, I am very new to VBA and I want to copy and paste text from pdf to excel using VBA and match it in specific cells on my spreadsheet. If possible, I was hoping to copy the sections by searching specific section numbers that lie beneath the desired section I want copied. For example...

Hi everyone, I am an Excel beginner, with basic knowledge. I am collecting Australian Football Data into Excel. I've gone through what the process is like below. I want to know how I can make this process more efficient and automated? Can I utilise a macro or something else that can copy...

Hello I want to start out with saying am not familiar with VBA programming and have been struggling with this task. I have been trying to do some research and figure out what I need to do to accomplish my task. What I am trying to do is go into a folder and pull specific data out of some excel...

Hello all. I hope everyone is safe. I need help on creating a Macro to cut cell from range 1 to paste cells on range 2 on same sheet Example: When i click on a button it will cut cells from A1 to C1 and paste on F1 to G1 Next each click goes through the table and do the same for the next until...

Hello I have the following VBA code which moves unique values from a range to another worksheet. The only issue is that does not exclude blanks - so it always copies one. Is there any modification I can make to skip the blanks? Sub GetUniques() Dim d As Object, c As Variant, i As Long, lr As...

Hi, I need some help with filtering and selecting specific cells with multiple criteria. I have a table with a list of fruits and their expiry date. I have tried using VBA to auto-filter the fruit data that are expiring in current month. (xlFilterThisMonth). However, I only want to select data...