Hello, I am hoping someone can help me with my dilemma, I don't even know where to begin coding this one.
I have a Workbook with 6 Sheets: TRACKER, FY19 SUMMARY, FY20 SUMMARY, FY21 SUMMARY, FY22 SUMMARY, FY23SUMMARY, and FY24 SUMMARY.
I need to move a portion of a row of data from the TRACKER worksheet to the appropriate FY SUMMARY worksheet based on Fiscal Year. There is a macro to place a Check Mark Symbol in columns E-I when clicked and a formula to calculate Expiration Date in Column K and Fiscal Year in Column M.
I need to append the cells in Columns A-L after the last row of data in appropriate Fiscal year worksheet when Column L is populated, I don't want any formatting or formulas to be copied, only the contents.
Each of the columns A-M have a header in Row 1 and each of the FY SUMMARY sheets have the same headers for rows A-L (Fiscal Year not copied).
I am going to place a Macro Button in the spreadsheet to perform the operation.
Any help would be greatly appreciated.
My TRACKER Sheet looks like this.
A B C D E F G H I J K L M
<tbody>
</tbody>
I have a Workbook with 6 Sheets: TRACKER, FY19 SUMMARY, FY20 SUMMARY, FY21 SUMMARY, FY22 SUMMARY, FY23SUMMARY, and FY24 SUMMARY.
I need to move a portion of a row of data from the TRACKER worksheet to the appropriate FY SUMMARY worksheet based on Fiscal Year. There is a macro to place a Check Mark Symbol in columns E-I when clicked and a formula to calculate Expiration Date in Column K and Fiscal Year in Column M.
I need to append the cells in Columns A-L after the last row of data in appropriate Fiscal year worksheet when Column L is populated, I don't want any formatting or formulas to be copied, only the contents.
Each of the columns A-M have a header in Row 1 and each of the FY SUMMARY sheets have the same headers for rows A-L (Fiscal Year not copied).
I am going to place a Macro Button in the spreadsheet to perform the operation.
Any help would be greatly appreciated.
My TRACKER Sheet looks like this.
A B C D E F G H I J K L M
Last Name | First Name | Rank | Unit | Member Sig. | Unit Com. Sig. | Group Com. Sig | MSG/Wing Com. Sig | SVS Approval | Approval Date | Expiration Date | Check Out Date | Fiscal Year |
Smith | John | Pvt. | 199 | X | X | X | X | X | 4/1/2019 | 5/16/2019 | 4/22/2019 | 2019 |
<tbody>
</tbody>