I have a spreadsheet set up so as I enter raw data in one sheet, it gets organized and formatted automatically in two others ("final" data). The number of rows pertaining the entered data varies but at the end of the "final" data I would like a bottom border to automatically be added. My thought was if I entered an if then statement in conditional formatting - for example: if the above row has text and the below row is empty then format the top of that cell with a border... but I'm unsure the best way to proceed.
After this I would like for the "final" data on the 3rd sheet to automatically be added below. I am familiar with formulas and excel but not fully comfortable with it - although I LOVE the program. I am sure everything I want to do would be best done via VBA - but I am not at all familiar with this nor would know where and how to proceed.
Thank you in advance!
After this I would like for the "final" data on the 3rd sheet to automatically be added below. I am familiar with formulas and excel but not fully comfortable with it - although I LOVE the program. I am sure everything I want to do would be best done via VBA - but I am not at all familiar with this nor would know where and how to proceed.
Thank you in advance!
