Importing Data in to Excel

[wakegirl814]

When you import data into a spreadsheet, I know that you can make a "snapshot" of the data or connect to the original source in order to capture any changes that are made to the data--there are also options within spreadsheets.

Please help me explain how to take the data as a snapshot and how to get changes as they happen for these 2 scenarios.

1) Sheet 1 has raw data. On sheet 2, I need a copy of a single column. How would I create the column on sheet 2 if I wanted it to change with changes in sheet 1 and if I do not want it to change?

2) Sheet 2 has manipulated my data into the desired format through a series of computations and formulas such that the column that I want to capture in sheet 3 if I want it to change with changes in sheet 2 and if I do not want it to change.

Could you help me come up with formulas or algorithms for these two please? Thanks!

[teylyn]

Well, this is not really importing, since your data source is already in Sheet1.

For Q 1): Copy the column on Sheet1, click Sheet2 and select Paste Special, tick the Values option and hit OK

For Q 2): I'm not entirely sure I understand this sentence, but if you want Sheet3 to show a column in Sheet2, and Sheet3 should automatically update its values when the result of a formula in Sheet2 changes, then use something like

=Sheet2!A1

This formula goes into a cell in Sheet3 and is copied down as many cells as you have data rows in Sheet2. It will take the contents of the cells in column A and display them on Sheet3. If contents in Sheet2 changes, Sheet3 will reflect these changes.

Does that help?

[wakegirl814]

Let me try to clarify my questions, as I realize it didn't really make sense in the first place.

1) I want to know how to copy data from sheet 1 to sheet 2 that will
a) change the values in sheet 2 when values in sheet 1 change
b) not change the values in sheet 2 when values in sheet 1 change

2) I want a column in sheet 3 that
a) changes with changes in sheet 2
b) does not change with changes in sheet 2
**changes to sheet 2 could deal with any of the data in sheet 2

Does this help clarify so that it is more succinct? Thanks for your help!

[teylyn]

i've given you the tools you need in my last post. use copy - paste special - values for stuff you want toremain static. use a formula like

=Sheet1!A1

for dynamic links. adjust sheet names and cell addresses to suit.

cheers

<sent from phone>