ejpuck
New Member
- Joined
- Nov 8, 2011
- Messages
- 15
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)"
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)"