copy & past rows vba

  1. I

    VBA code to Copy values to another workbook

    Hello guys, I'm new to VBA coding, so I used an AI to generate a code for me, but it didn't work as I intended. I have a workbook with dozens of worksheets, my idea was to put a button with this macro to copy the same cells range of the active worksheet and to paste this values as a new line...
  2. U

    Creating Workbooks with Page Breaks

    I have a spreadsheet with data that are separated by page breaks. I'm trying to figure out a VBA script that: create workbooks after each page breaks save in the same folder as the current spreadsheet with the naming convention (ex. Workbook 1, Workbook 2, etc.) each workbook needs the same...
  3. O

    Copying rows based on text in cell if not already existing in new sheet

    Hi, I want to check column D:D for the text "Offentlig" and copy the entire row into another sheet. But if the row already exist in the other sheet i dont want it to copy and paste it, which my code does. If a new row is added with the text "offentlig" in the corresponding D cell i want this to...
  4. E

    VBA - Copy and paste rows if conditions have been met

    I need to copy row data from one sheet to another if yes is in column BE, No match in coloums BL, BM and BN and if Column BO is blank Can any one please help, i have tried the below code but its not working Private Sub filter() For i = 2 To lastrow If Worksheets("Data Only").Cells(i...
  5. S

    Copying rows to new sheet referencing master

    Hi there, first post so hopefully I am doing this correctly. I am trying to create a process with another program (Revit) for creating formatted schedules (tables). I have plugins that update parameters in our program with an excel file and back. Basically, I want to have a master sheet and...
  6. W

    Code doesn't work when switching tabs

    Hello, I have VBA code which copies information from one spreadsheet to another. The original spreadsheet has many tabs, and when I use the code in it's current form, it throws this error when I try to copy over the columns from a tab that's different to the one that the spreadsheet opens on...
  7. I

    Copy and Paste Filtered data from another file & autofill month in pasted data

    Sub Manpower() Dim lastRow As Long Dim Wrkb1 As Workbook Dim Wrkb2 As Workbook lastRow = Worksheets("Manpower Details").Range("C" & Rows.Count).End(xlUp).Row Set Wrkb1 = Workbooks.Open("D:\DU\MIS.xlsm") Sheets("Manpower").Select If ActiveSheet.AutoFilterMode Then...
  8. R

    Copy Paste as Excel using VBA code

    Hello, I have an inventory of equipment, radios, and vehicles that is updated by many users. This update is sent either in total or in part to a fleet manager for insurance purposes. I have set up a user form for the department heads to use when an update is required. The user form allows the...
  9. L

    Please help - how to optimize all the copying and pasting

    The code below is looking through items in Column A on sheet 'Key', then find match in Column A of sheet 'Match1' and copy the first 8 cells of each matched row on sheet 'Match1' to sheet 'Result'. Can you please look through the following questions by priority? Okay to not have all three...
  10. QualitySoup

    VBA to move row values from one sheet to empty row.

    Hi, Everyone! I'm trying to find a way to have values copy to the first empty row on a separate sheet. Below is the code that I am working with from @My Aswer Is This. All I need is for excel to find the first empty row from top to bottom and "paste" it there. Private Sub...
  11. D

    copy-paste the last 600 columns in sheet 2

    want to copy past the last 600 columns of d and e in sheet2. Sheet 1 column values are dynamic in every 5 min its increases
  12. An Quala

    Multiple Times Paste within the same sheet

    Hello, It's a pretty straightforward issue, I need to paste a set of rows (template), available in the first 3 columns of the excel sheet multiple times, for instance, 500 times, can anyone please help me to that with a VBA Code? I am a very beginner with VBA. Thank you. C4
  13. B

    Copying from one sheet and pasting to the next empty row is no longer working

    Hi guys and gals... I am having a nightmare and need some help! I am trying to filter my data by a specific column (in this case Column 'D') and then copy the filtered data to another worksheet in the same workbook. I have basically copied and pasted some VBA script I used on another project...
  14. E

    Copy and Paste and If Statement Issues

    I have two issues. 1. I would like to be to run two If statemetns If Audit area Combobox is Blank return all values and run the if statement for the report range or If Audit Area combobox has a value return that value and run the if statement for the report range 2. Once that is done I...
  15. I

    VBA Loop Data Copy Across Worksheets

    Hello everyone, I am quite new to VBA and trying to learn it by creating the complex scenarios in the random excel calculations. I have a question regarding using VBA to copy the data across worksheets. I would appreciate if you could kindly help me with it. I am trying to copy multiple data...
  16. M

    Macro to help with a reporting feature!

    Hi all - I have been trying for a week now through chopping up bits of code to try perform a report function to help with some data analysis but it is hopeless and keeps failing. I have 3 sheets within my work book: Master Data Data Input Duplicates All three sheets contains the same headers...
  17. I

    A button to make selected cell and copy several columns below it..

    I wont to make a button (1),That have function copy several column (2), form selected cell (3). To other worksheet which already prepared (4)
  18. S

    Copying selected columns in background and pasting values in a separate sheet

    Hi All, I have the following code that opens a csv file in background, copies everything between Cell A1 and BF from that csv file and then pastes in a a separate sheet. I would like to modify this code so that it copes only Column A and BF from the csv file that is opened in the background...
  19. K

    VBA code to copy paste from multiple workbook to one workbook

    Hello everyone, I want to copy paste data from multiple workbook to single workbook. I have created sheet names Master Macro and in the sheet3 i have mentioned the names of the files(which is usually our employee names). VBA should go to the folder and fetch data from a sheet named "Rawdata"...
  20. S

    VBA to automatically copy rows to multiple cells

    Hello forum! Currently we have a table of client data with multiple categories of details, something like this: Our ultimate goal is to translate this file of data into a pivot table, where it counts based on the conditions (let's say from columns AU:BC), to something like this: However...

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