Yooks
New Member
- Joined
- Apr 2, 2021
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi peeps,
Sorry for the botched subject, I have no idea how to word the macro I am seeking.
Quick Summary:
So I want to keep hard values in the master sheet.
Visual example:
I want to copy the attendance data for employees 3167, 5001, 8538
In this case they're all together.
Now we head over to the master sheet, these employees are all on different rows.
Therefore, I would need a way to paste the attendance data into the row which the employee resides.
Thanks in advanced to anyone willing to tackle my issue. I appreciate it!
Disclaimer: The data in the visual examples are examples only and do not contain any real employee info.
Sorry for the botched subject, I have no idea how to word the macro I am seeking.
Quick Summary:
I want a macro to copy the data from all rows in one sheet, then paste the data from
those rows into a "MasterSheet" but in specific rows where the employee number resides for this example.
I know I could use a formula to complete such task, however, due to the fast paced environment, rows and value gets changed or deleted every so often. So I want to keep hard values in the master sheet.
Visual example:
I want to copy the attendance data for employees 3167, 5001, 8538
In this case they're all together.
Now we head over to the master sheet, these employees are all on different rows.
Therefore, I would need a way to paste the attendance data into the row which the employee resides.
Thanks in advanced to anyone willing to tackle my issue. I appreciate it!
Disclaimer: The data in the visual examples are examples only and do not contain any real employee info.