So I have somewhat of a complex requirement that I need some help with in VBA.
I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook, and then separate that information between 2 tabs based on a certain date. For Example;
Payroll Tracking (Workbook) - Datasheet (Tab) - Table1 (Table)
Can you help?
I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook, and then separate that information between 2 tabs based on a certain date. For Example;
Payroll Tracking (Workbook) - Datasheet (Tab) - Table1 (Table)
- Copy/paste the values of Table1 into a new workbook within the same folder as Payroll Tracking (Create a new workbook?)
- Create 2 tabs in new workbook, Call Center & eTechnologies
- Separate the copy/paste data based off the value of Table1 - Pay Start (Column) (Only 2 sets of dates in this column, the earlier one goes to Call Center, the other goes to eTechnologies)
Can you help?