How links cells of two different Excel files.

Hi friends from today we are start our tips & tricks section.

Our first topic is how links two cell by formula. For our example we first save two different files with two different names.

Let assumed name of the first file is “first.xls” and the second file name is “second.xls”.

Now first discuss about the case.

Suppose in first.xls file we have stored some detail of our customer which fields are “Name” in the column A, “Address” in the column B, “Credit price” in column C.

A B C

Name Address Credit price

In second.xls file we have stored some extra data which also include a same filed which is same with the first.xls file. The second.xls file may be look like

A B C

Customer name Product name Price

Now start our programming first we have enter some customer detail in first.xls the two same field are in the second.xls which are Name and Credit price.

We don’t want to enter the same data on both the file.

Now open the both file (first.xls, second.xls), activate second.xls window then select b2 cell then enter the formula “=[first]Sheet1!$A$2”, then drag the formula from b2 to b20(as per your requirement).

Again select C2 cell and type the formula “=[first]Sheet1!$C$2”, drag the formula from c2 to c20 (as per your requirement.

Now save both the work book and close it. Open first.xls and enter some data in it save it and close it. Open the second file what you see the data which is enter in the first cell it is automatically copy in the B and C column of the second.xls file.

Note: - Remember one thing you must be put the both file in the same directory for get the result if one of the file is missing from the directory you can not get the proper result.

You also can write a formula by doing this, put “=” in a cell then select the cell which value you want and press enter you formula is written automatically.

Moving and Copying Data and formulas in Excel

Hello friends how are you today we are learned about copying and paste feature of Excel. Actually copy and paste is not only two commands. Excel used the maximum feature of copying and paste function than the other software. So let’s start.

Copying cell contents by dragging and dropping: -

The easiest way to move or copy a cell or range of cells is to drag the cell or the range of cells to the new location and drop it.

1. Select the cell or range or range of cell you want to move.
2. Move the mouse pointer over the selections border. The pointer changes to an arrow.
3. Drag the pointer and the gray outline of the selection to the new location. Drag past the edge of a window scroll. Go to the point where you want to paste the data.
4. When you rich to the point where you want to paste the data simply release the mouse button when the gray outline is where you want to place the selected range.

To copy cell’s contents using drag and drop, do this:

1. Select the range of cells you want to copy.
2. Hold down the Ctrl key and move the pointer over an edge of the selection. The pointer becomes an arrow with a + (plus) sign.
3. Continuing holding down Ctrl key as you drag the edge of the selection to where you want the copy. The copy’s location appears enclosed by a wide gray border.

Using the drag-and-drop method, you can make only a single copy. You cannot copy to multiple locations or fill a range.

If you release the Ctrl key before you release the mouse button, the copy operation. The plus sign next to the arrow disappears. You can press Ctrl key again to switch back to copy operation.

Copying data across a Workbook:

1. Select the cell or range of cells you want to copy.
2. Click the Edit menu and choose Copy. Alternatively, click the Copy button on the standard toolbar or press Ctrl + C. The cells to copy appear, surrounded by marquee.
3. Select the worksheet to which you want to move data.
4. Select the cell at the at the top-left corner, where you want the duplicate to appear.