Executive Human Resource At Emcure Pharmaceuticals
Harsh Shukla
Ceo And Md Of 3 Uk Based Mnc's
+7 Others

Thread Started by #Anonymous

Dear Friends,
Please Help me!
I need to creat a excel leave form which i did, and now i want to connect it to another excel worksheet where all employees names and their information is stored.
In other words if i type a name of a person, all details related to him in the other sheet should automatically fill in the form so I have to only enter his leave dates in the form.
Kindly Help,
Thanks In advance!
21st March 2013 From Kuwait, Kuwait
Hi Anonymous,
This is quite easy actually.
You will first of all have to input all the required data, lets say you do this on the first exel worksheet.
Now lets say you wish to transfer the data from cell C3 on Sheet 1.
Then on the second worksheet select the the cell you wish to transfer to and insert the following formula:
=Sheet 1!C3
Your data has been transferred.
You will need to do this for every cell.
Hope this helps.
21st March 2013 From United Kingdom, Barrow
I appreciate Harsh but let me clarify what I really want I have employees names and their details like Joinnind date, salary and allowances ect. on one sheet for around employees, now I have created a Leave form where all empl. details has to be filled in and I need to just select one name in leave form and form will automatically upload all details related to that name in the leave form hence I dont have to keep filling all the details of the employees requesting the leave.if you have some tips for this kindly share.
21st March 2013 From Kuwait, Kuwait
Dear sir, plz help me in learning PF calculations and require formulas in calculating the employee salaries Regards, Ramesh
21st March 2013 From India, Pune
Hi Agyabdul,
I am fairly certain that what you are looking for cannot be done on an excel sheet.
However, if you go to AllExperts Questions & Answers and click on Computing/Technology on the right hand side. then Spreadsheet Q&A, on the left hand side. Then click on the heading Excel, you will get a list of experts willing and able to help you. On the right hand side you will find a list of experts, i can recommend Tushar Sakhalkar, i have used his expertise several times and he is very helpful.
Hope this helps,
21st March 2013 From United Kingdom, Barrow
Hi, Use vlookup of lookup function in excel. you can lear by using excel help. hope this will solve your proble. for this you shoul have data in table format in excel.
22nd March 2013 From India, Mumbai
Dear friend, Use vlookup formula and get whatever you want. if any problem to you give me your remote i will show you. Mahadev Jadhav 9028245258
22nd March 2013 From India, Mumbai
please find the enclosed record file, hope this will help u and you can change & adjust your record as per your requirement,
thanks & regds
if any confusion, please feel free to contact
22nd March 2013 From India, Gurgaon

Attached Files
Membership is required for download. Create An Account First
File Type: xls Record.xls (23.5 KB, 3654 views)

Yes totally agree with all those who said "V Lookup" option will work. Its very easy.. You need to add the V look up formula for only one row and copy it for all other rows, blank rows where you want your data to be copied from different sheet.
For example; if you enter the employee name in the defined area, all other details related to that employee gets automatically updated. For this you should have master data sheet.
This saves lots of data entry time, spelling mistakes, errors etc..
23rd March 2013
Hi, With vlookup or lookup or INDEX function use absolute and relative reference properly. for building reports use pivot table.
23rd March 2013 From India, Mumbai
Hi Hope the sheet attached is of some help. Thanks Regards
23rd March 2013 From India, Vadodara

Attached Files
Membership is required for download. Create An Account First
File Type: xls LEAVE WITH WAGES CAL SHEET.xls (139.0 KB, 733 views)

Best is to write a Macro, and let the Macro do you work. If you send the data file, I will try with Macros. Gautam Shastry
25th March 2013 From India, Visnagar
I have just joined the community ... please help me
I want to create excel form in which i want to enter the data and this automatically be updated in next excel sheet and form on another sheet...... simply a form which update data sheet automatically.. sorry for my poor english
20th April 2015 From Pakistan
Dear Sir/Madam, I entered 2 or 3 or any number in Sheet 1 today.I need the date of entered number in another Sheet 2.How can I update please help me.
15th April 2017 From India, Bangalore
I have to fill some data in multiple form, how can i get.
22nd August 2018 From India
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2017 Cite.Co™