I have a pretty simple question. Whenever I add columns to a sheet, my vlookups and/or sumifs (located on a different sheet) that reference this sheet are now off by one and I have to go and Find and Replace them to account for the new column. How can I make excel do this automatically whenever a column is added??
*side question: can i get this forum to e-mail me when someone has replied to a post?
Bookmarks