Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy data from the top cell of a filtered list to anothe.
How do I get a cell at the top of my spreadsheet to pull the data from the
top cell of a filtered column since the cell number itself is changing? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy data from the top cell of a filtered list to anothe.
range("yourrange").specialcells(xlvisible).cells(1 ,1).copy
or range("yourrange").specialcells(xlvisible).cells(1 ,1).entirerow.copy -- Don Guillett SalesAid Software "Brian" wrote in message ... How do I get a cell at the top of my spreadsheet to pull the data from the top cell of a filtered column since the cell number itself is changing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
formula to find the data of a next cell in a list | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |