Dear all
Can you help me with a very time consuming task.
I have these data with peoples travel allowances, what I need to do is
Extract;
1. Name in ROW A
2. Personal Nr ROW B
3. Country ROW L
4. City Row K
5. Distance ROW D
6. Nr of persons > 2Years ROW C
7. Full Year ROW F
8. Total Payment ROW I
Into an individual sheet for all names so that they can receive it and view for themselves.
The individual sheet has a template where
Names should be placed at row A4
Country in A20
City in B20
Distance in C20
Standard travel allowance in D20
No.of persons > 2 year in E20
Full Year F20
Comments G20
Rappel H20
Total to Pay I20
I deleted the names as they are confidential but I need to send out 137 individual sheets taken from the master file
PLEASE PLEASE HELP![]()
Bookmarks