registration

Hello All, I have multiple vehicles at work and we make multiple drops during a day. I am currently downloading a days’ worth of information for the entire fleet and would like to rank the individual vehicles by the first job completed and then ascending all by the time it was completed (I...

Hello, I recently took over a position at my work and I am working with a file that was not originally mine. I have warranty registration cards that we receive from our dealers once the item is sold to the end user. When the end user reports a failure they are supposed to submit a credit form...

Good Afternoon, I quite new to excel VBA so sorry if I've not posted correctly. I was wondering if there I away to run a Macro that will check a MOT date and return the date the MOT is due. I.e if I have got a registration number in cell A1 and another registration in A2 and so on, I won't...

I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for...

Good day to you all, I need help. I am trying to create a column for late fees, if either Registration Date (C) or RX received (D) are LESS than 30 days from Camp Start date (I). Basically if we receive either the registration or the Rx less than 30 days from camp session start date I have to...

<tbody> First Name Last Name email address registration date #day since registration John Smith john.smith@gmail.com 2018/04/29 360 Jane Doe jane.doe@gmail.com 2018/04/29 360 </tbody> Hi, I need to be able to send an email to a individual if the number of days between...

hi sorry new to forum and pretty new to VLOOKUP, VBA etc, have played with various things that half do what I want but can't find exact solution I have two workbooks, one where vehicle hire booking's are stored there is a start date column, end date column and registration column, I then have...

Sorry my Title might be misleading! Here is what I'm looking for. In column D is the date a vehicle is request to be used from in column H is the registration for the vehicle that will be used. I want column m to tell me if that registration input in column H is already in use for the date in...

Hi guys, would appreciate any help with this please. Trying to return min and max for values for blank (?) columns below. So here's the logic: Table 1 IF Type column="Bulk", then Vlookup Transponder column and match to Table 2 Transponder column and return min date Note: Transponder value...

Hello I have created a registration userform. People come to the PC, enter they badge number and register for an event. After they register the userforms background turn green. => registration OK If for some reason the user try's to register again the userforms background turns red. => Already...

Hi Guys, as indicated, the numbers marked in red are the expect results, process and registration fee will be extracted from table 3 and cost will be extracted from table 2; couldn't really pinpoint what formula to use, a few look ups ? could you help me with any formulas with regard to this...

Hi Guys, I would like to have the values from the Revenue and cost sheet tranferred to the work sheet respectively: <tbody> Work sheet Jan Serial number Process fee Registration fee Process cost Registration cost 123525 5245+5647-5475 5648 5245+5647+5475...

Hi Guys, I Need some help with regard to when certain cells have value and return to colour-shaped Status: I have 2 different workbooks: one indicating: <tbody> Jan </tbody> <tbody> <tbody> Serial number </tbody> Process fee Registration fee process cost Registration cost...

Hi All, im trying to lookup a few conditions (registration and status of vehicle from one worksheet) and then display comments in another worksheet. The main issue is i cant use vlookups as the registration in the reverse sheet is there multiple times which is why i need to use the status...

Hi All, I am trying to calculate fuel cost/emissions from a fleet of vehicles and equipment, and I have data going back to July 2016. I have separated each month, but within each month there are still times when a vehicle has refueled, meaning there are multiple duplicates for each Registration...

I have two worksheets named as "Records" and "Summary". In column D of worksheet "Records" there are registration number of different subjects (format "0000/2017, 000/2017, 00/2017, 0/2017, 000/2016, etc.).The occurrence of registration number of particular subject (which is unique number) is...

Hello everyone I am looking for some assistance from someone more experienced than I am in Excel. I have a massive database that contains the car registration no. for all employees. The database is on 2 different sheets, one covering single drivers and the other one car sharing drivers. The 2...

good morning! I have a list on a worksheet (Registration) that contains information in the table below: (there are 4 people per hole) this spreadsheet will eventually have 40 holes or so, and 400ish people. P R S W X AB AC AG...

I have a Excel Template, the workbook has sheets named "Data " and "Pivot". The data I pull comes from a CSV file which i open as excel file which i copy and paste to the "DATA" sheet Column N. When i execute the macro it formats it the way i want it and dumps the pivottable to the "Pivot"...