I’m new to this site and especially to coding in VBA. I can do simple macros but am trying to write one for the following. I have 2 worksheets:
Summary, which has the button I’m trying to write the vba for
Data, which stores all of the data (like a database)
When “Enter Data” is hit, I would like the 7 cells to the right of the button to be filled into the right spot, based on an ID number, on the Data sheet by inserting a row. I am trying to write an application that will find the ID number on the Data sheet, find the right block of data (I’m trying to use a pointer for this), and then fill in the information. I would like the Data sheet to only keep the five most recent entries and sort in descending order. I don’t quite know how to find the right block of code (this is why I’m trying to use pointers) and once found, how to insert a row in the right spot
I’ve included my mismash of code below and a sample sheet (in 2 files as the file was too large together). Any advice would greatly be appreciated. Thank you!