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