Get Data in difference sheet

  • Thread starter Thread starter Kazaam@Work
  • Start date Start date
K

Kazaam@Work

Dear All,

I like to ask any experts know how to get data form sheet 2 into sheet 1
Thx you very much

From
Kazaam
 
Hi Kazaam!

Here's the basics as you don't give us much to go on.

In sheet1:

Select a cell that you want data in
Type =
Click on Sheet2 Tab
Point to and left click the cell you want to copy
Press Enter.

You'll get a formula that looks like this:
=Sheet2!A21

If you re-name Sheet2, you'll find that the formula will update itself
for the change.
Copy down the formula to the next cell and it becomes =Sheet2!A22

There's more that can be done but we need more details on what you
have and what you want.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top