copy & paste

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...

Hi, I am new to VBA and need some help with some of the procedures I would like to automate. I have two excel files to work on - employee and contract data. Basically, I need to find employees who end their contracts in the current month that I open the file. (For example, if I open the file in...

Everyone is familiar with the "Paste Column Widths" command that will take information from the clipboard and use it to transfer the column widths of a copied range to another range without including the actual data from the cells that were copied. Thus, it seems to me that when a range of...

I have a large database of information in Excel (no other software choice unfortunately) in which others want to insert data into, without worrying about entering the data into the wrong cells and dirtying up the data source sheet. Said others are not Excel-savvy, and as such I need to prepare...

Sub mM() ' ' m Macro ' ' Keyboard Shortcut: Ctrl+Shift+M ' Workbooks("Academic").Worksheets("Manpower Details").Activate Range("B" & Rows.Count).End(xlUp).Offset(1).Select 'ActiveCell.Value = Format(Now(), "Mmm yy") Dim ws As Worksheet Dim lastRow As Long Dim Alastrow...