copy column data from one sheet to a different column on another sheet

[ejpuck]

Ok, this shouldn't be that hard. It's very easy on google docs, but I cant find the equivalent excel answer.

I have two sheets, each with its own sets of headings. I am continuously importing data into the cells bellow the headings on one sheet.
When imported, I want that data to automatically post into the correct corresponding columns in the other sheet.

The following is an answer I found this answer elsewhere, but of course it doesn't apply to excel. BTW, I'm looking for the "fancier" solution as I have no idea how many entries I'll eventually have.

"Finally, if you want to be "fancy" and have one formula that brings over an entire column of data, rather than just one cell and copying the formula down the column, you can do an "arrayformula".
Example:
If you want everything in Column A to be in Column D, then you can enter this in Cell D1:
=arrayformula(A1:A)

If Column A is on Sheet 1, and you want this in Column D of Sheet 2, then enter this in cell D1 on Sheet 2:
=arrayformula('Sheet 1'!A1:A)"

 

[BenMiller]

In A2: =IF(INDIRECT(ADDRESS(ROW(B2),MATCH(A$1,Sheet1!$1:$1,0),,,"Sheet1"))=0,"",INDIRECT(ADDRESS(ROW(B2),MATCH(A$1,Sheet1!$1:$1,0),,,"Sheet1")))

But that will display nothing even when the cell has a value of 0; not only if it's actually empty.

Alternatively, you can format your cells as accounting, so the zeros will just be little dashes; if the zeros are too much of an eyesore.