Bijay_majumdar
Freelancer In Hr &indirect Taxes For
Suhaskhambe
Executive Human Resource At Emcure Pharmaceuticals
Harsh Shukla
Ceo And Md Of 3 Uk Based Mnc's
+6 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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!

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.
Regards,
Harsh

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.
Dear sir, plz help me in learning PF calculations and require formulas in calculating the employee salaries Regards, Ramesh
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,
regards,
Harsh

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.
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
HI,
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
regds
ROHAN
8860567680


Attached Files
File Type: xls Record.xls (23.5 KB, 3752 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..

Hi, With vlookup or lookup or INDEX function use absolute and relative reference properly. for building reports use pivot table.

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™