Hi everyone,
I need your help in creating some macros please. My level is completely beginner so I understand more than I can do. I am tasked with very repetitive tasks several times a day where I have to copy and paste some data, with all the errors that this could entail. I know what I would like to achieve so I have made a "wish list" of tasks and I was hoping that if some of you can help me with any part of the project or the whole project I would be greatly appreciated.
I know how to create buttons and assign macros, also how to copy data into a new worksheet but when I try to group then I start to fail - this can give you an idea of my level!
Here is my wish list (project) and I attach a sample workbook:
1. Create 2 buttons in Sheet “PM-PA Assignment of Personnel” to copy certain columns from Sheet “PM-PA Assignment of Personnel” into other Sheets in the same workbook grouped by values in column “PAF Status” and separated by a heading per each status (Approved, Pending, Rejected), as seen in Sheets below. These new created Sheets should be positioned to the left of Sheet “PM-PA Assignment of Personnel” and tab name be highlighted red.
a. Overall PAF Status Internal
b. Overall PAF Status Client
c. Miscellaneous PAF Client
2. Make calculations on PAF Status totals at bottom of page
3. Copy values of Sheets (b and c) into new sheets in new workbook and attach in an email -Can this be done?
4. Ideally insert pie chart at bottom of Sheet “Overall PAF Status Client”
5. Copy values of Sheet (a. Overall PAF Status Internal) into a new sheet in new workbook and attach in an email
6. Create another button in Sheet “PM-PA Assignment of Personnel” to copy certain columns into Sheet “Overall PAF Status OT”
7. I would also like to create a button in Sheet “PM-PA Assignment of Personnel” where the value of some columns of a selected row are copied into a separate template workbook with 2 Sheets and then this workbook saved as a new workbook with the name comprised of the values of columns B – H I (Is this possible?)
8. I don’t suppose there’s a way to populated a, b, and c Sheets as they are being entered in Sheet “PM-PA Assignment of Personnel” and assigned a “PAF WER No” ?
Once this is done I would like to explore if the following can be done but maybe this is my "dream list":
9. Create Form to input basic details: Name Surname PositionTitle DateStart DateEnd Justification Comments
10. Link to workbook PAF Register so that values are entered directly into Sheet “PM-PA Assignment of Personnel” in the first empty row under heading “PAFs in Preparation”
11. All other column values to be entered manually or calculated through formulas in Sheet “PM-PA Assignment of Personnel”
Thanks so much
I need your help in creating some macros please. My level is completely beginner so I understand more than I can do. I am tasked with very repetitive tasks several times a day where I have to copy and paste some data, with all the errors that this could entail. I know what I would like to achieve so I have made a "wish list" of tasks and I was hoping that if some of you can help me with any part of the project or the whole project I would be greatly appreciated.
I know how to create buttons and assign macros, also how to copy data into a new worksheet but when I try to group then I start to fail - this can give you an idea of my level!
Here is my wish list (project) and I attach a sample workbook:
1. Create 2 buttons in Sheet “PM-PA Assignment of Personnel” to copy certain columns from Sheet “PM-PA Assignment of Personnel” into other Sheets in the same workbook grouped by values in column “PAF Status” and separated by a heading per each status (Approved, Pending, Rejected), as seen in Sheets below. These new created Sheets should be positioned to the left of Sheet “PM-PA Assignment of Personnel” and tab name be highlighted red.
a. Overall PAF Status Internal
b. Overall PAF Status Client
c. Miscellaneous PAF Client
2. Make calculations on PAF Status totals at bottom of page
3. Copy values of Sheets (b and c) into new sheets in new workbook and attach in an email -Can this be done?
4. Ideally insert pie chart at bottom of Sheet “Overall PAF Status Client”
5. Copy values of Sheet (a. Overall PAF Status Internal) into a new sheet in new workbook and attach in an email
6. Create another button in Sheet “PM-PA Assignment of Personnel” to copy certain columns into Sheet “Overall PAF Status OT”
7. I would also like to create a button in Sheet “PM-PA Assignment of Personnel” where the value of some columns of a selected row are copied into a separate template workbook with 2 Sheets and then this workbook saved as a new workbook with the name comprised of the values of columns B – H I (Is this possible?)
8. I don’t suppose there’s a way to populated a, b, and c Sheets as they are being entered in Sheet “PM-PA Assignment of Personnel” and assigned a “PAF WER No” ?
Once this is done I would like to explore if the following can be done but maybe this is my "dream list":
9. Create Form to input basic details: Name Surname PositionTitle DateStart DateEnd Justification Comments
10. Link to workbook PAF Register so that values are entered directly into Sheet “PM-PA Assignment of Personnel” in the first empty row under heading “PAFs in Preparation”
11. All other column values to be entered manually or calculated through formulas in Sheet “PM-PA Assignment of Personnel”
Thanks so much