Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 273
- Office Version
- 365
- Platform
- Windows
Hi,
I have created a roster application, but on occasion I will need to swap hours rostered between employees.
My data is as follows:
I have 10 employees, and I capture data relative to their working day in 15 columns. I would like to be able to enter two employee names in 2 adjoining cells and hit a button that has the 'swap' macro assigned to it. So I need the employee name to stay as they are (no swap) and the data contained in the 15 adjoining cells to be swapped.
Is this possible?
Apologies in advance I'm not a programmer....
Hope somebody can help - Many Thanks.
I have created a roster application, but on occasion I will need to swap hours rostered between employees.
My data is as follows:
I have 10 employees, and I capture data relative to their working day in 15 columns. I would like to be able to enter two employee names in 2 adjoining cells and hit a button that has the 'swap' macro assigned to it. So I need the employee name to stay as they are (no swap) and the data contained in the 15 adjoining cells to be swapped.
Is this possible?
Apologies in advance I'm not a programmer....
Hope somebody can help - Many Thanks.