Copy a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to enter the data from A2 on sheet 1 into cell B3 on
sheet 2 and have the data from A3, A4, and A5 on sheet 1 automatically go
into C3, D3, and E3 on sheet 2. I have a database with over 10,000 entries
and would like them all to work like this. Any suggestions? Thanks a bunch!
 
You only have 256 columns to work with on a sheet. You will either have
to start a new sheet, put data in additional rows, or buy Excel 2007. As
far as "the data" automatically going into, well that is a case of how
you want to do it, you could copy, Paste special, transpose.
 
Back
Top