Need a macro which copy values from rows and paste into a table

Closed
khan436 Posts 1 Registration date Saturday March 23, 2013 Status Member Last seen March 23, 2013 - Mar 23, 2013 at 10:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2013 at 10:51 AM
Hello,

Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg

S# Name Basic Allo1 All2 All3 NTN Special Overtime (Column Headings. Total 9 Headings and down is their corresponding values)

1 abc 1000 800 500 300 230 200 300
2 xyz 1000 500 300 400 100 300 100
3 txy 900 400 300 350 200 250 150


Now when the salary is calculated and dispatched to bank for processing, we print salary slips for each employee. The slip is in tabular form like this:

Basic = 1000
All1 = 800
All2 = 500
All3 = 300
NTN = 230
Special = 200
Overtime = 300

Net Salary = 3330 (Thats for employee 1 i.e Name abc)


Imagine our staff do it manually for 900 employees!!! So I've joined this company a few days before and I want to automate this process to save time.

So I need a macro which makes the slip for next employees automatically... please help me solve this problem.... I'll much appreciate. Please feel free to ask any question to understand the scenario.

Thanks.





Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 23, 2013 at 10:51 AM
0