vba code for

In a sheet some 6000 rows are there. Id's are repetitive with different dates. I just want that macro will check the no. of repetition of each id and if the repetition is more than 12 times then it should delete the oldest date. (It means 12 times repetition is fine. If an id is repeated 13...

Hello, I am trying to accomplish the following: In my workbook I have a master spreadsheet named PLC Config. In PLC Config there are eight different cell value options (SPARE,ECOM,AI,AO,AIAO,DI,DO,DIDO) for cell range B12:N12. The same cell value options are present in cell ranges B15:N15...

I have a weather dataset of over 5000 entries. The entries have hourly recorded values for each day from 20th-Jan-2006 to 31st-Aug-2006. I have to separate every day by inserting three rows and in those rows i want three formulas which calculate avg, min, max for of the different parameters of...

<tbody> S.No Year Name / Number Rationcard Number Application_id Caste Village Applied Area(Ha) Irrigation Type MI Company 1 2017-2018 Jem 521037 00878539-2017-18 Other Caste Srirangarajapuram 0.7 Drip EPC Industries Ltd., 2 2017-2018 Ketty 571480 00905816-2017-18 Other Caste Theiyar 0.88...

Hello Again, I have a code running (code below) that is copying data from one master sheet, to one of 2 other sheets based on criteria. What I need to do now, is add a code to this (for the whole workbook) that will track changes made. So if by example, John opens the book, and enters a new...

Hi Working with Excel 2016 I'm receiving a "csv" file from a 3rd party program with dates in column "A" but it is text and I can not format it to a date in excel. I'm looking for a VBA code that will take the text values in column "A" like 16/09/2015 for 16-Sep-2015 and like 03/11/2015 for...

Dear All, I have developed a user form with multiple text boxes and combo boxes. Request your assistance in writing the VBA code, which detects and pops message of DUPLICATE ENTRY, as soon as something (say ID number) is typed into the first text box or when tab is pressed to move to the next...

I have another issue where I'm stumped, I've used this same code on 5 different other forms and it performs as it should on them but on my current worksheet, it continues to "overwrite" the previous data instead of moving to the next line in the table. My code is as follows: On Error...

I have been viewing different codes over the internet for 4 days and I can't seem to get this to work correctly. I have a named range called "REVBUD" and when selecting any cell within that range, the amount selected is supposed to paste so a table called budget. It does paste but when I go to...

I have Pay slip in one folder "C:\Users\ABC\Desktop\All My Desktop File\SS\Salary File\Staff\6. Oct-14\PaySlip" I have one Excel File sheet 1 which has all employees Name (Column "A: A") All Name are match with folder pays lip name and Column "B: B" has email address. So is there any way to...

Hello All, I am looking code for save as PDF in excel 2013, i have one sheet (Summery) Calculation all data. other Sheet (Payslip). i am using Lookup formula to get data from Summary. i am using Below code for printing all Payslip in one time. same like that i want Save AS code. Please help me...