I have a series of excel spreadsheets that come in the same format, but there are varying numbers of rows. I have to add four columns with equations in each to be run on the existing data. I know how to add the columns. I cannot get the equation to fill to the bottom of where the existing data is. For example, existing data covers range A2:A24 in Spreadsheet 1 and A2:A29 in Spreadsheet 2. I have code that inserts a column with an equation next to A in B2 on spreadsheet 1, but I cant write the code that will fill that equation to B24 on SS 1 and to A29 in SS 2. I know this is confusing, but hopefully someone can help.
Bookmarks