paramveer
Member
Hi Sir,
Please solve my problem
In my Job, i make salary bills of about 110 employee in excel
& also do the function of calculation of income Tax.
I use a bill file named "bill 1" in folder name "3" which relates to March Month
similarly In next month i use folder "4" i.e. April salary with similar named
Here is my problem Now i create a file (in example) in which i want to put brief detail of whole year salary of particular employee by using "VLOOKUP" formula
but this file become very heavy and hang the excel as well as my computer.
What can i do
If you give solution with example it become more helpful for me
Please solve my problem
In my Job, i make salary bills of about 110 employee in excel
& also do the function of calculation of income Tax.
I use a bill file named "bill 1" in folder name "3" which relates to March Month
similarly In next month i use folder "4" i.e. April salary with similar named
Here is my problem Now i create a file (in example) in which i want to put brief detail of whole year salary of particular employee by using "VLOOKUP" formula
but this file become very heavy and hang the excel as well as my computer.
What can i do
If you give solution with example it become more helpful for me