What is tyhe best way(without vba) to copy all data in a column from one sheet to another.
Here is what I am needing to do
Dates are going across in cells A1:Z1
Data is below each date from A2:A57 and so on.
On a seperate sheet I am trying to copy an entire column based on the date. So If the date given is in G1 then all of the data in column G will copy from sheet1 to sheet2.
Thanks for the help.
TB
Can you upload sample workbook?
It won't "copy" but it will appear. If your date is in G1, put this formula in G2 and copy down:
=OFFSET(INDEX(Sheet1!$A$1:$Z$1, MATCH(G$1, Sheet1!$A$1:$Z$1, 0)), ROW()-1,,,)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I don't think you need the OFFSET(). This would suffice:
=INDEX(Sheet1!2:2,MATCH($G$1,Sheet1!$1:$1,0)) and dragged down
Last edited by Cutter; 04-30-2012 at 07:01 PM.
Here is a sample sheet. I could not get either of those to work, but I am sure I was doing something wrong. Thanks again.
In Sheet2 G3 put this formula:
=INDEX(Sheet1!3:3,MATCH(G$1,Sheet1!$1:$1,0)) and copy over and down
That's great, Cutter. ;
TB, if that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
Thaks again for help. Marking Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks