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

[Closed]
Report
Posts
1
Registration date
Saturday March 23, 2013
Status
Member
Last seen
March 23, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.





1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768