We're creating a tracking system for our vendors. I want to input pricing by month for each item we buy from each vendor. In another workbook, I want to display only the most recent price we've paid.
Is there a way to tell Excel to reference the rightmost cell of an array that contains data?
Bookmarks