Hello folks,
I am not an expert at excel, so not sure how to resolve this issue.
I have two excel worksheets:
File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc.
File 2: Full-Pop: This file has a complete...
Hi, I need to maintain a list of clients for a specific purpose.
For this I receive a daily report with a list of clients that fit into this criteria and I need to identify when the daily report and the clients it contains changes. I need to identify when clients appear on the report as well...
I am attempting to compare lists of data and insert missing rows. The below code is intended to do so, however, if it encounters an items in the Account Master List that is not on the Execute billing list it will insert rows for everything that comes after that row of data. Any help is...
Hello forums,
I have a dream of an Excel macro or tool that would make my job infinitely easier, but attempting to cobble it together on my own from Google and forum posts has not proved fruitful.
One of my job duties is to take reports that are exported nightly and compare them to determine...
Hi Guys,
I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet
i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...
Hello all,
I am trying to develop a script that would compare sheet 2 to sheet 1, with differences on sheet 3. I am trying to find out when my customers are advancing orders within standard time. Below is the small piece of last two order sheets.
Sheet1:
<tbody>
</tbody>
<tbody>...
I am trying to loop through the items in SampleData2.xlsx and match them to the items in SampleData1.xlsx. If the item matches, I want to take the price and put it in the Column labeled "Complete". If anyone could offer some guidance, it would save me hours and possibly my sanity. Is this...
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.