I have a spreadsheet where I summarize data monthly. I have the months in columns. Each month, I add a column full of data. On another sheet, is the most recent month's data. For example:
What I am looking to do is automatically fill SHEET2's data based on the right-most column of data. When I put information in for April, I would like SHEET2 to automatically update with April's data. I can do this in VBScript easily enough but then I have to maintain the VBScript along with all of the signing or macro warnings.
What is a formula to put into SHEET2's data columns to get the most recent month of data?