Excel - Pass data b/w sheets

[FlixMixIntern]

Hi,

Here is what I would like to do. Can anyone help me?

On sheet1 of my Excel file, I have a column called "Title". What I would like to do is punch in a formula on sheet4 that will copy the entire contents of the column from sheet1 and paste it on sheet4.

I thought I should use the Lookup routine, but I am not sure if that is the right one, and I don't know how to properly use it.

For reference, I'm using Excel XP. Thanks.

Cameron...

 

[xlhelp]

in Sheet4 type in
=Sheet1!A1

if your data is in column A and copy it down as far the data should extend. There are different keystrokes that you could use etc., but in the end it's the same task you are performing.

 

[FlixMixIntern]

yes, but I have something like 100 cells in this column. Will I need to edit this forumula for each cell, so it would look something like this...

=Sheet1!A1
=Sheet1!A2
=Sheet1!A3
=Sheet1!A4


and so on. Or, could I just use a wizard that will save me a whole bunch of time. Thanks.

Cameron...

 

[FlixMixIntern]

I see, if I copy and paste this formula, it will alter it for me. Now, another question...

In each cell on the new sheet that has no corresponding data from the first sheet, a "0" is printed. How can I alter the formula so that it will not put in this number? Thanks.

Cameron...

 

[carrr]

Try... =IF(ISBLANK(Sheet1!A7),"",(Sheet1!A7))

 

[carrr]

...should have said Sheet1!A1.....not to be confusing....