Hi all
I have a Workbook with month tabs. On each tab I am using the same range of columns - A:X with the rows growing down as the month goes on. The rows grow differently every day. Some days there could be 1 new record, other days 100.
What I'm trying to achieve is a VBA that will put a border around all cells for the new records once I have filled in the information.
Also I need the VBA to fill down the new rows with the current date in column A. Along with filling down the formulas that are in columns V, W & X.
The end result will be all those columns down filled and a full cells border added to the new records per day with the click of one button.
My VBA skills leave a lot to be desired, so I'm reaching out to you guys for help. Is what I'm looking for even possible?
Thank you in advance
I have a Workbook with month tabs. On each tab I am using the same range of columns - A:X with the rows growing down as the month goes on. The rows grow differently every day. Some days there could be 1 new record, other days 100.
What I'm trying to achieve is a VBA that will put a border around all cells for the new records once I have filled in the information.
Also I need the VBA to fill down the new rows with the current date in column A. Along with filling down the formulas that are in columns V, W & X.
The end result will be all those columns down filled and a full cells border added to the new records per day with the click of one button.
My VBA skills leave a lot to be desired, so I'm reaching out to you guys for help. Is what I'm looking for even possible?
Thank you in advance