copy & past rows vba

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

VBA loop until blank- Sheet 1 B4 copy, paste it Sheet2 C3, copy the result sheet2 D3, paste it in C4 on Sheet1, next row in sheet 1 (example B5). Continue until blank in Sheet1 column B. This is my first ever post so let me know if you need more info. Thanks!