I need help writing code that sorts a worksheet containing data for employees in the form of dates, and copies to multiple sheets based on the value in column "C". Employees work different units; each unit has one sheet for it's specific data.
Problem - I have been able to get the data copied accurately, but unable to paste if the row size on both sheets is inaccurate. In addition, I have created a row just under the data that contains statistical information, that I do not want to have "pasted over" when rows are inserted. Data is pasted from another database to the sheet "All Nursing Staff" when updated. I would like to be able to assign a macro to a command button to copy and paste the data to individual sheets for each unit when updated.
My Code:
![]()
Please Login or Register to view this content.
Bookmarks