I have employee data broken down by employee name, id, deduction month, deduction code, and deduction amount. I want to use VBA to combine the rows with the same employee id, list the deduction codes, and total the deduction amount. I want to do this but leave it separated by deduction month...
I am working on a Classroom Files.
Where i have many files containing report of each test like Test 1, Test 2, Test 3...
I have to make a Master workbook that will contain the Mark Columns from All the Test Files
I tried the PowerQuery ( I am very much new to PQ) but failed as it was...
Hello,
I need to find a way to take an excel sheet that has employee names listed several times in Column A and then it has several earnings codes in column b with earnings amount in Column D with different data and find a way to combine all the data also in the other rows together so I don't...
Good Afternoon,
I want to create an Excel Spreadsheet which automatically closes after a certain time of being idle as multiple users need access to it.
I have found coding for that but unfortunately for it to work Macros need to be enabled.
I have found what I need which works separately but...
Hi,
I am trying to combine shipping address information but some cells are blank e.g. some addresses have a company name, some don't which leaves an empty line.
I am using the below formula.
=A2 &CHAR(10)& B2 &CHAR(10)& C2 &CHAR(10)& D2 &CHAR(10)& E2 &CHAR(10)& F2
How can I make it so if a...
Hello
I found this example (function) that makes all possible combinations of different ingredients, I want to add a condition that every ingredient can only be used in certain position ( column)...
Any help would be much appreciated
Hello,
I have just started with VBA and I need your help. I've attached a picture and I will try to explain my problem. In "lastat"-sheet, I will add stock/pallets that I will move to another warehouse. With "Move"-button i move numbers to "Lagersaldo"-sheet. This warehouse will use...
I have a very large spreadsheet with headers (180k+ rows) with unique ID's in A, start date in B, and end date in C. There are multiple rows per ID and the start and end dates overlap in a messy way.
I need to find any gaps in the date ranges for each ID. I've written a few different formulas...
Hello,
I need help with combining these two codes into the Worksheet_Change sub, I can get them to work on their own but can't combine them properly.
In the first sub I am ensuring users enter a date in the date field when entering data in other columns in the row:
If Target.Cells.Count > 1...
Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost).
Is it possible, via M code or otherwise, for me to group by...
Hi All,
I will be having around 85-90 password protected workbooks. They all will have different passwords. I shall collate them in 1 folder.
I will have a list of the workbooks name and their passwords (preferably in sheet2).
I need a macro or code which will open the workbook with the...
Hello,
I am looking to create a macro where i can combine two sets of data based on a ratio.
I am pretty good with macro's but i cant seem to work this one out.
I want to start with an easy ratio of 1:1, so i have two data sets 'MLA' and 'PLA' and i want to combime them on a 3rd tab in the...
Hi,
I have three tables showing Plant, Material and Labour quantities from each of my crews on site,
The tables are linked by unique identifiers or "Shift Report Numbers", however, multiple items assigned to each unique identifier. For example:
Shift Report Number
Date
Job Code
Labour...
Hi,
Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows.
In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...
Hi All,
I am trying to get a vba code to copy information from different files to one destination file but on different worksheets on the destination file.
The destination file is called "Master data file ".
The master file has worksheets named ""Sheet1","Project1" , "Project2"...
Hello Everyone
I have two workbook in one path and both have same headers.
I have code to merge both the workbook into one but then i need to combine them into one worksheet. like copy data from one sheet to paste on another sheet last filed row
Sub GetSheets()
Dim Path as Integer
Path =...
I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...
Hello all experts : )
I would like to Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another)
Below are some screenshots from the files I would like to merge, there are 130 files.
Let's start with smaller sample, I would like to combine file 117 and 22...
Hello,
im having trouble with coming up with a formula for the following case:
We have sheet with data about different products:
Product
Quantity
Location
Product 1
5
1-1-1
Product 1
10
1-1-1
Product 1
5
1-1-2
Product 2
10
1-1-2
Product 3
5
1-1-2
Product 3
10
1-1-3
Our...
Hi,
I am trying to figure out how I can get from table one to table two with formulas or some easy VBA. As you can see I want to make one row for John and one for Jenny, instead for two as it is now. The date should also be combined so that the first start date and the last end date shows. E.g...
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.