ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I import data from 1 excell workbook to another? (https://www.excelbanter.com/excel-worksheet-functions/191200-how-do-i-import-data-1-excell-workbook-another.html)

agarrettbell

How do I import data from 1 excell workbook to another?
 
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

robzrob

How do I import data from 1 excell workbook to another?
 
On Jun 13, 8:23*pm, agarrettbell
wrote:
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


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com