Hi All,
Could you please assist? I have a bit of excel knowledge but not VBA.
We have a commission sheet of about 400+ rows of each employees commission calculations which are in various categories, such as connections, insurance sales, accessories etc. I want a button to be able to copy only specific values from the rows into a prelim "salary slip" that are in columns format to email to staff.
We work on employee numbers.
From this: (One row per employee)
Emp No Accessory Qty Accessories com OMS Connections Connection Commission
781 23 605.12 44 1 560.00
To this: (One Summary table per employee)
781 R
Contract connections 0 -
Warehouse Connections 0 -
Accessory Sales 0 -
Not sure if it makes sense. There are columns in between that don't need to be copied over.
Basically, I want the program to take the raw data and if it matches that employee number, copy for example data from column I to Accessory Sales, copy value in column P to Contract connections, etc.
Copy from Commission Sheet to Prelim Sheet.
We have already set up Macros to email their prelims, but we copy and paste data manually at the moment for 400+ employees and it's too much work.
Thank you in advance for the assistance.
Bookmarks