Hi All! First time poster here...I recorded a macro that finds the last row and selects the 9th column cell on the next row down (and have it running upon opening the workbook). Works fine right now, but I did notice that the LastRow value is not dynamic, so I need to make an adjustment to allow it to be so, as I add data to this sheet every day. (The macro is at the bottom of the image). Is there better VBA code (offset from LastRow?) that will accomplish this? I also want to add the same code to another sheet that is much different dimensionally. This one shown below is currently 40815 rows and 53 columns, and will only represent a years' worth of information.
Please let me know! Thanks!
Please let me know! Thanks!