Hello. I'm creating a table that will include a column with numbers for the current year/month as well as a column for prior year/month. In the rows I have different categories. I want to link this table to a tab that has the row headings (for the table) in the left column and the months going across the columns. I could just manually select the cells that I want to include but I want the numbers to update based on the month. So, if I April in a cell, it will automatically grab the data from the year/month (the tab has the dates along the top row). How can I do this? Various methods welcome. Thanks!!!!
Bookmarks