| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a
You will have trouble at A255 unless you have Excel 2007.
Tom wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a
I have 2000, what can I use to get it to work up to A255?
"Bob I" wrote: You will have trouble at A255 unless you have Excel 2007. Tom wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a
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. Tom wrote: I have 2000, what can I use to get it to work up to A255? "Bob I" wrote: You will have trouble at A255 unless you have Excel 2007. Tom wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Linear Mode
