Colon Cleanser Natural Detox Formula. Odd Ball Hilarious Unusual Wedding. Update Formula To Include Cells Automatically Adjust' title='Update Formula To Include Cells Automatically Adjust' />Excel Data Entry and Update Form. With this Excel data entry form, you can enter or update records on the data entry worksheet named Input. It is a bit late now, but the below formula will do exactly what JacMars was looking for, just enter this in visual basic, anytime you have an entry in column B. A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations. X locations, the columns, are normally represented.