| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy every 5th cell in the column to different worksheet
I want to copy every 5th cell in the column to different worksheet. Could you
advise me? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 5th cell in the column to different worksheet
Let's say we want to get every fifth cells from column A in Sheet2. In the
new sheet at the top of any column enter: =INDIRECT("Sheet2!A" & ROW()*5) and copy down -- Gary's Student "EE_TRAINER" wrote: I want to copy every 5th cell in the column to different worksheet. Could you advise me? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 5th cell in the column to different worksheet
Or a variation of the same formula
=INDIRECT("Sheet1!"&ADDRESS(ROW()*5,1)) entered in a1 of sheet 2 Regards Peter "EE_TRAINER" wrote: I want to copy every 5th cell in the column to different worksheet. Could you advise me? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy every 5th cell in the column to different worksheet
Enter A5 and A10 in the new sheet (NO equal sign!)
Use the fill handle & drag down as far as you want, for example, the last few items would say A195, A200 Select all, Edit/Replace, replace A with =Sheet2!A and you have it. Bob Umlas "Gary''s Student" wrote in message ... Let's say we want to get every fifth cells from column A in Sheet2. In the new sheet at the top of any column enter: =INDIRECT("Sheet2!A" & ROW()*5) and copy down -- Gary's Student "EE_TRAINER" wrote: I want to copy every 5th cell in the column to different worksheet. Could you advise me? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Linear Mode
