| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to copy cell data
Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is names
of states. BUT Would the formula be diffrent if it were numers? Also how / when & which do I use - click & drag or the autofill handle thing? I can't just do copy/paste or I'll lose points on test!! I need the formula. THANKX ConCarp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to copy cell data
Put in B12: =IF(A4="","",A4)
Copy B12 down to B17 (Drag the fill handle at the bottom right corner of B12) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Concarp" wrote: Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is names of states. BUT Would the formula be diffrent if it were numers? Also how / when & which do I use - click & drag or the autofill handle thing? I can't just do copy/paste or I'll lose points on test!! I need the formula. THANKX ConCarp |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to copy cell data
In B12, =A4 and drag it down to B17, no, it makes no difference whether its
text or numbers, Regards, Alan. "Concarp" wrote in message ... Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is names of states. BUT Would the formula be diffrent if it were numers? Also how / when & which do I use - click & drag or the autofill handle thing? I can't just do copy/paste or I'll lose points on test!! I need the formula. THANKX ConCarp |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to copy cell data
YOU GUYS ROCK!!
THANK YOU SOOO MUCH! CC "Alan" wrote: In B12, =A4 and drag it down to B17, no, it makes no difference whether its text or numbers, Regards, Alan. "Concarp" wrote in message ... Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is names of states. BUT Would the formula be diffrent if it were numers? Also how / when & which do I use - click & drag or the autofill handle thing? I can't just do copy/paste or I'll lose points on test!! I need the formula. THANKX ConCarp |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to copy cell data
YOU GUYS RIOCK THANKX SO MUCH!!
"Max" wrote: Put in B12: =IF(A4="","",A4) Copy B12 down to B17 (Drag the fill handle at the bottom right corner of B12) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Concarp" wrote: Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is names of states. BUT Would the formula be diffrent if it were numers? Also how / when & which do I use - click & drag or the autofill handle thing? I can't just do copy/paste or I'll lose points on test!! I need the formula. THANKX ConCarp |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to copy cell data
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Concarp" wrote in message ... YOU GUYS ROCK THANKS SO MUCH!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
