Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
I want to grab the values from one worksheet and display them in another, but I only want every other value. Presently I'm using a simple auto fil and then going back and manually changeing the column letter. Example Sheet 1 5 10 4 2 5 2 3 4 5 6 Sheet 2 5 4 5 2 4 6 -- MABeatty ------------------------------------------------------------------------ MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258 View this thread: http://www.excelforum.com/showthread...hreadid=547065 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
Hi, try this formula in A1 on Sheet2 then fill it across and down...
=INDIRECT("Sheet1!" & ADDRESS(ROW(),COLUMN()*2-1)) Any blank cells on Sheet 1 in this range of cells will appear on Sheet 2 as zeroes. If that is not to your liking then use this formula... =IF(ISBLANK(INDIRECT("Sheet1!" & ADDRESS(ROW(),COLUMN()*2-1))),"",INDIRECT("Sheet1!" & ADDRESS(ROW(),COLUMN()*2-1))) If Sheet 1 has a different name such as Silly Sheet Name then use... =IF(ISBLANK(INDIRECT("'Silly Sheet Name'!" & ADDRESS(ROW(),COLUMN()*2-1))),"",INDIRECT("'Silly Sheet Name'!" & ADDRESS(ROW(),COLUMN()*2-1))) OR... =INDIRECT("'Silly Sheet Name'!"&ADDRESS(ROW(),COLUMN()*2-1)) Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
Hold down the Ctrl key and highlight the columns you wish to copy, then do
COPY, and Paste them into the new sheet.........they will be consecutive there. hth Vaya con Dios, Chuck, CABGx3 "MABeatty" wrote: I want to grab the values from one worksheet and display them in another, but I only want every other value. Presently I'm using a simple auto fil and then going back and manually changeing the column letter. Example Sheet 1 5 10 4 2 5 2 3 4 5 6 Sheet 2 5 4 5 2 4 6 -- MABeatty ------------------------------------------------------------------------ MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258 View this thread: http://www.excelforum.com/showthread...hreadid=547065 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
MABeatty wrote:
I want to grab the values from one worksheet and display them in another, but I only want every other value. Presently I'm using a simple auto fil and then going back and manually changeing the column letter. Example Sheet 1 5 10 4 2 5 2 3 4 5 6 Sheet 2 5 4 5 2 4 6 One way is to: 1) Transpose original data 2) Use Autofilter to show every second row 3) Copy the results of the filter to the other sheet 4) Transpose the new data |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
Too easy:-) Call me a pillock! Ken Johnson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill, Every other column
The "simple" ways are the only ways I know.....everything else makes my head
hurt......<g Tomorrow starts Hurricane Season...(sigh) Vaya con Dios, Chuck, CABGx3 "Ken Johnson" wrote: Too easy:-) Call me a pillock! Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill option | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |