Search : in
By :

Excel query

Last answer on Jan 16, 2009 5:43:48 am GMT Sam, on Jan 15, 2009 9:37:03 pm GMT 
 Report this message to moderators

Hello,

I want to know how to copy a data from cell of one workbook to cell of another workbook which has same data in different cell?

For example

Work book one

Col A B C D
1 ID Name
2 5 sam
3 6 ram
4


Work book 2
Col A B C D
1 Name
2 ram
3 sam
4 jam


Now to be more specific which formula to use to directly paste information of id in workbook 2 from workbook 1 of respective name.

Thanks

Sam

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Excel query » in :
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Download EMS SQL Query for PostgreSQL ShowTo store and handle your information, the use of a database such as PostegreSQL simplifies your task. By means of different queries, you can easily extract information which you need at any time. EMS SQL Query for PostgreSQL is a program to...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...

1

 netgear3, on Jan 16, 2009 5:43:48 am GMT

Hi,
try this link, you will get a list of formulas used in Ms excel:

http://office.microsoft.com/en-us/excel/HP052001271033.aspx

there you can search for the formula you need.

Reply to netgear3