copy

  1. R

    VBA Script for copying a range of cells from multiple worksheets into one worksheet?

    Hi all! Knocking out a huge project for work and I'm looking for anything to save time. I have successfully imported ~100 workbooks into a single workbook as sheets, labeled "3" to "103". From each of those ~100 sheets I'd like to copy the data in cells A11:Ax, C11:Cx, E11:Ex, and I11:Ix (from...
  2. N

    Copying and pasting a long row has issues

    Hi Wanted to see why I can't properly paste an entire row on cells like a few weeks worth from online excel to a die loaded excel file The copy part isn't the issue only the paste part And I think the message I get is The data your pasting isn't the sane size as your selection. Do you want...
  3. T

    Making the contents of the active cell the search term, and search using that term, copy paste row, next

    I have a large Excel data base of bacteria Genus'and i need to match the name in one worksheet, to another worksheet, copy that whole row, and paste into another worsksheet. Example... I have 3 worksheets A, B, C Worksheet A has 1000's of rows of names and many columns of data to each row...
  4. M

    Copy cell color to another sheet

    I am very new to VBA. I have been trying to find the right VBA stuff to use to be able to copy over colors from another sheet. There are 6 different sheets in which I want to change the colors on the first sheet and want the designated cells in the next 5 sheets to change colors. I feel like I...
  5. Agnarr

    VBA problem with creating new sheets

    Hello everyone! I have made a sort of registry crm where one enters product code and quantity, excel returns name of product and price*quantity, plus it calculates start and end registry, loses, gains and other stuff. Some macros that clear specific cells and 2 more macros that: 1. user enters a...
  6. D

    Copy Duplicate and Remove/Update Original Text

    For each row where there is text in column E, copy the entire row and insert it below the original row. Then remove the text in column E from the row that was copied.
  7. B

    Copy a specific Worksheet from multiple Workbooks into one Workbook - one Worksheet

    Hi So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them) I would like to be able to...
  8. T

    Searching for data in column, if found Cut it paste on other sheet

    I want to search Column "b" for "98" and if found (could be multiples line) I want those lines to be cut and pasted in a new sheet called "Diesel Discount" This is what I got so far. If it Highlighs the first End With as error... Sub Move_Diesel_Discount() Dim LR As Long, i As Long With...
  9. J

    COPY PASTE USING VBA CODE

    I have this problem. I want to create another workbook and paste the values of specific starting cell and select down to the end. Then, I want to copy the values starting at cell AP41. the sample output was shown in the picture output1. in my source file, I have 100 sheets, I want to loop on the...
  10. brendalpzm

    Copy worksheet into a new workbook

    Let's say I have 2 workbooks and i have to create 1 wb1 = workbook with the macro wb2 = worbook with the info so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook Idk if i explained...
  11. L

    VBA to find match of cell value on two different Spreadsheet and then copy adjacent cell (value and format)

    Hello, I have two spreadsheets named New.xlsx and Old.xlsx. I'm looking for a VBA code that compare each column T values (unique ID) in New.xlsx with values in column T (unique ID) in Old.xlsx. When there is a match, it then copy the value and cell format (e.g. cell color) of the cell in column...
  12. S

    How can I automate copying rows to another tab BUT always add the newest additions to the end?

    Hi All, Sorry if that isn't very clear. What I have is a spreadsheet where I have a MAIN LOG, which I use to keep track of client appointment and report timescales. That all works fine, so don't worry too much about that. What I need help with is this. When 'Y' is entered in Column R (indicating...
  13. C

    Copy value based on dynamic input

    Hey all, I have a problem and have NO idea how to solve it - it is about a dynamic sheet that should show a timeline (Calendar weeks) and quantities in that timeline. Attached is an sample workbook with all information -> 20230522_SAMLE_WORKBOOK.xlsx But here are additional information: B12 &...
  14. D

    Copying data from Excel sheet into Word

    Hello, When I copy from a Excel sheet data into Word it rounds the numbers behind the . I think all this is because of all the different cell formats all the columns have. Is there a way to copy and paste the data with all the numbers behind the . like 12.03767 ? After copying in Word this is...
  15. S

    Copy cell value via VBA if specific cell is changed

    Hi to all I need some help to change the code that I use to copy value... This code I use: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range If Not Intersect(Target, Range("B2")) Is Nothing Then Set rng = Range("C2") rng.Value = Range("A2") Else If Not...
  16. L

    Userform with path to sharepoint and copy pdf file to my folder

    Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...
  17. brendalpzm

    Copy data from a range and paste it in the next available row in another sheet

    I have a range ("A31:AB31") in the "Input incidents" sheet, so I need to paste it (only values, no formulas) at the next available row in a data base ("Incidents_Accu"), the columns are also A:AB in the data base, the information should be accumulated in the data base by clicking on an ActiveX...
  18. G

    How to make Array work with header name having 3 words

    I need to find certain columns based on header name in 1 sheet and copy them to another. My code works for "Task Type" and "User". However it does not copy the other columns. I tried using 2 words and it worked. For ex. Instead of "User Email Address", I changed the column header and array to...
  19. A

    Multiply different excel files based on a cell value in a master file and rename them

    Hi! I am trying to find an automated process in VBA for a very time-consuming task. This is my monthly table: column A Column B Column C Column D Store type How many stores? Type of file template New name of the file Store 1 4 1. 2023_Store 1_C1._feb.xlsx 2123 Store 1 Store 2 2...
  20. P

    Type Mismatch when defining workbooks

    Hello! I am probably doing something wrong but I keep getting an error and I dont know how to fix it. The long and the short of it is I have to copy data between three different excel workbooks Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook ' Set wb1 = ActiveWorkbook Set wb2 =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top