vzachin
01-10-2011, 09:37 AM
hi,
i have an excel 2007 file that exceeds 65000 rows. is there a way of extracting a few columns (eg: column b, d, e) using excel 2003 without opening the 2007 file?
basically what i'm looking for is to get the data excel 2007 columns b,d,e and place the data into excel 2003, columns a,b,c. then when it reaches row 65536, place the data into excel 2003 columns e,f,g
thanks
zach
i have an excel 2007 file that exceeds 65000 rows. is there a way of extracting a few columns (eg: column b, d, e) using excel 2003 without opening the 2007 file?
basically what i'm looking for is to get the data excel 2007 columns b,d,e and place the data into excel 2003, columns a,b,c. then when it reaches row 65536, place the data into excel 2003 columns e,f,g
thanks
zach