How do I import data from 1 excell workbook to another?

A

agarrettbell

I take information off of 1 handwritten piece of paper & enter parts of it
into 3 differant Excell workbooks to track various data. I am looking for a
way to enter all the information into 1 workbook and have certain data
(cells) to import to other workbooks depending on the report I need.

I can only find instructions for importing external data. When I try to
import from another excel workbook the entire worksheet is imported. I need
the steps to follow in very simple steps, please
 
R

robzrob

I take information off of 1 handwritten piece of paper & enter parts of it
into 3 differant Excell workbooks to track various data. I am looking for a
way to enter all the information into 1 workbook and have certain data
(cells) to import to other workbooks depending on the report I need.

I can only find instructions for importing external data. When I try to
import from another excel workbook the entire worksheet is imported. I need
the steps to follow in very simple steps

Open all your worksheets. In the cell you want the data to appear in,
type =

Click on the cell in the other worksheet where the data value you want
to import is

Enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top