Hello fellows excelcionals! as the title say i have a huge report that at the moment there is a lot of manual editing on lots of cells that are pretty much repetitive so i thought there is got to be an easier way to do this. look at the example below:
1. row is title "Earnings" , first level goes all the way to column BG, then a new headers begins"Taxes" with it's own 2nd header and then a third "header"Taxes ER" and then a 4th header "Deductions"
2 2nd Row is a second level header
3. 3rd row, is two column header under second row.
goal is the following: on the third row, i would like to show like this:
Object is to add " REG" to "HRS" and where the word amount is replace with "REG", "DT", etc. whatever the second row header is then that should be copy down. Anyway, i hope to do this to :
* Earnings
*Taxes
*TaxesER
*Deductions
The Range of columns covers from A-JZ and includes all the 4th 1st level headers above mentioned. hope i didn't confuse you. thank you so much in advance , you will save me a good 30-45 minutes having to do this manually.
1. row is title "Earnings" , first level goes all the way to column BG, then a new headers begins"Taxes" with it's own 2nd header and then a third "header"Taxes ER" and then a 4th header "Deductions"
2 2nd Row is a second level header
3. 3rd row, is two column header under second row.
goal is the following: on the third row, i would like to show like this:
Object is to add " REG" to "HRS" and where the word amount is replace with "REG", "DT", etc. whatever the second row header is then that should be copy down. Anyway, i hope to do this to :
* Earnings
*Taxes
*TaxesER
*Deductions
The Range of columns covers from A-JZ and includes all the 4th 1st level headers above mentioned. hope i didn't confuse you. thank you so much in advance , you will save me a good 30-45 minutes having to do this manually.