pull data from one sheet to another sheet

July 6, 2016 at 22:42:13
Specs: Windows 7
EMP_NO 127063
PAN_NO AJTPS7349J
MONTH YEAR
3 2015
3 2015
4 2015
5 2015
6 2015
7 2015
8 2015
9 2015
10 2015
10 2015
11 2015
12 2015
1 2016
2 2016

TOTAL :
Gross salary Income
Govt Ontribution to NPS
HRA Exemption
Transport Allowance
Total Income
Total Professional Tax
Interest on Hsg. Loan
Income From Other Source
Int on NSC/BANK Dep/UTI/Share
Gross Total Income
Ded under Ch (VI-A) of Sect.
(Sec-80,80-CCC etc.,)

Total Exemption
EMP_NO 131061
PAN_NO AKSPK8793N
MONTH YEAR
3 2015
3 2015
4 2015
5 2015
6 2015
7 2015
8 2015
9 2015
10 2015
10 2015
11 2015
12 2015
1 2016
2 2016

TOTAL :
Gross salary Income
Govt Ontribution to NPS
HRA Exemption
Transport Allowance
Total Income
Total Professional Tax
Interest on Hsg. Loan
Income From Other Source
Int on NSC/BANK Dep/UTI/Share
Gross Total Income
Ded under Ch (VI-A) of Sect.
(Sec-80,80-CCC etc.,)

Total Exemption
EMP_NO 131068
PAN_NO AOHPD6855K
MONTH YEAR
3 2015
3 2015
4 2015
5 2015
6 2015
7 2015
8 2015
9 2015
10 2015
10 2015
11 2015
12 2015
1 2016
2 2016

TOTAL :
Gross salary Income
Govt Ontribution to NPS
HRA Exemption
Transport Allowance
Total Income
Total Professional Tax
Interest on Hsg. Loan
Income From Other Source
Int on NSC/BANK Dep/UTI/Share
Gross Total Income
Ded under Ch (VI-A) of Sect.
(Sec-80,80-CCC etc.,)

Total Exemption
EMP_NO 130262
PAN_NO AOPPD8327N
MONTH YEAR


EMP_CODE NAME
111072 R R GORAKHIA
126081 T P NAIR
126082 P SUNDARESWARAN
125041 N M SHIRKE
126093 S G PEDAMKAR
127066 V B ADVANI
123032 M J SHAHAKAR
124046 SAVITHRI S

emp_code should be filled with new emp_code 6 digit where emp_code exist in another sheet one by one

message edited by deepak97


See More: pull data from one sheet to another sheet

Report •

#1
July 7, 2016 at 00:19:47
Deepak,

firstly please use the pre tags when posting code or structure of your sheets, this allows us to understand how your data is set out.

Read this
http://www.computing.net/howtos/sho...

Also include the sheet names for each set of data. Finally rather than telling us what you want, it would be much better is you explain to us what you are trying to achieve and maybe we can help. from what you have posted above I don't understand what you are asking us.....

message edited by AlwaysWillingToLearn


Report •
Related Solutions


Ask Question