Hello,
I am trying to automate a monthly process where I am receiving a set of data. The column width is the same, but rows can vary drastically. I automated a formula in the last column, and I am duplicating it for every row, but the formula is being pulled to the end of the sheet, instead of to the last row that has data. How can I stop the code from going past the last row containing data? And I am trying to accomplish this using the automate tab in Excel.
Thank you
Bookmarks