Pre-payment has been sent.
I have a table (Table1) located in the 'Snapshot' tab of the attached file. Table1 begins on row 11 (header row on row 10). I am looking for a macro that will copy the Format of the 2nd row of the table (row 12) and apply that format to the remaining rows of Table1. The reason for this is due to having another macro that imports new data into the table and when it does, some rows end have a different formatting than the existing rows (Wrapped Text, column A not bolded). I normally use the Format Painter option and manually adjust the data. Was hoping to accomplish this with a macro. Attached sample file for reference.
Thank you and let me know if you have any ?'s