license

hello friends, please help, my boss want me to make a reminder due to expiry date of our license. the alert must be based on (the expiry date - 10), and the pop up will display the No.License. the expiry date is in column I No.License is in column F <colgroup><col width="27"><col...

I am trying to create a formula: I want the formula to do as follow if cell A2 = any number for example 100 then cell B2 will equal 1 <tbody> 100 1 110 6 115 9 </tbody> the purpose of this is to match the database with license numbers and ranking based on those license numbers...

Good Day I have 11 checkboxes on a userform. When I select a checkbox and write the data to excel sheet, the unselected checkboxes return a False Value and the checked is blank in the Sheet whereas it should return True Value which does not. Thanks Code is as follows: Private Sub...

I have some coding below that provides a "license key" of sorts for the workbook. While writing it, I've messed something up (that's probably obvious) because each time I open the test workbook, it asks me for the license key. The "expirationdate" is a specified cell with an end date set 360...

Hi, I have data in > 2,500 CSV files to aggregate, clean and reduce to 2 columns. Each file contains at mininum an address and restricted key word e.g. 1 Abbey Road, License Submitted (key word in bold) Some files have more than 1 address and key word, e.g. 1 Abbey Road, License Submitted, 2...

I have this predicament... I have several excel files with some similar information, but not the same. I get edited copies of these files every week. There is no way that the people sending me these files will ever change how the files are formatted so I have to take all four files and create a...

Hey, So, I'm trying to create a monthly parking list for my office. we got X employees, and 2 parking spots. I got 2 sheets: 1. Employee Details - List of employee names, list of license plate, and if the employee wishes to use the parking or not. 2. Results - A list that should be field with...

Hi! I have a situation where my Excel spreadsheet has become so large and unwieldy that I'd like to have some of its data in one sheet and some in a second sheet. The data can all be connected by a primary key, in this example the license plate of a car. The first sheet will list information...

Hello, I've really looked online and attempted to copy/paste but I'm having difficulty with this. I am trying to develop a vehicle database for my company so that all employee cars are documented (each tab represents a specific department). That's the easy part. What I'm having issues with on...

Hello experts, I have different license plates belonging to various companies, but that can be "drafted" to other companies. It is easier to explain it sample data: <tbody> License Plate Company Start Date A1 AAA 01-01-2017 A2 AAA 01-01-2017 A2 BBB 01-12-2017 </tbody> On another sheet...

Hi there, I get an awful government report every month that I want to have a macro that will automatically copy and paste multiple times. The file looks like this when I get it: <tbody> License Number License Status UWI Deemed Asset Value Deemed Liability Amount PVS...