T
Tarig
Hi,
Below is an abstract of my payroll sheet. I know how to use goal seek to
change Basic Salary so Net Salary equals Proposed Net Salary, my problem is
that I have 800 lines to change, Is there any way I can repeat goal seek
through macros or anything that can save me the hassel of doing it line by
line?
Basic Salary Allowance1 Gross salary Tax Net Salary Proposed Net
Salary
1000 200 1200 120 1,080
1,400
2000 300 2,300 270 2,030
2,500
Thanks in advance
Below is an abstract of my payroll sheet. I know how to use goal seek to
change Basic Salary so Net Salary equals Proposed Net Salary, my problem is
that I have 800 lines to change, Is there any way I can repeat goal seek
through macros or anything that can save me the hassel of doing it line by
line?
Basic Salary Allowance1 Gross salary Tax Net Salary Proposed Net
Salary
1000 200 1200 120 1,080
1,400
2000 300 2,300 270 2,030
2,500
Thanks in advance