How can I import data from one sheet to another of same workbook automatically?

Question

PLZ EXPLAIN IN SIMPLE WAY. I TRIED IT FROM IMPORT DATA OPTION OF TOOL BAR IT IS TOO CONFUSING. FOR EXAMPLE IF I WANT TO COPY DATA OF COLUMN D OF SHEET 1 TO COLUMN D OF SHEET D OF SHEET 2 WHAT STEPS SHOULD I FOLLOW.

Answer 1

Let's assume cell D1 on sheet 1 contains the number 123. In cell D1 of sheet 2, enter this formula: =Sheet1!D1

Cell D1 on sheet 2 will now display 123.

(You can copy this formula, placing it in other cells in column D, to make the data from column D of sheet 1 appear in column D of sheet 2)

The formula =Sheet1!D1 has these parts:
= identifies it as a formula
Sheet1 is the name of an Excel worksheet
! is a separator (required) between a worksheet name and a cell name
D1 is a cell name (also called 'reference')

Answer 2

Click on the Header of the source column of Sheet 1.
Right Click. Select COPY.
Select Sheet Two.
Right Click on the header of the column (Destination).
Select Paste.

If you have to copy the whole sheet to another sheet. Follow the following steps.

1. Go to Cell Reference 'A1' (Of sheet 1)
2. Press 'Ctrl + A'
3. Press 'Ctrl + C'
4. Go to Sheet 2
5. Go to Cell Reference 'A1' (Of sheet 2)
6. Press 'Ctrl + V'

Entire Data is copies / imported.

Happy Excelling.

Parag

Answer 3

Excel I presume.
You can use a Filter.
You can link the two sheets with a Copy and Paste Special, Paste link. This uses more memory.

Answer 4

This formula did not work for me in Excel 2010. Do I use VLOOKUP? and if so, what do I include after it and what symbols do I use?