Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Dynamic Range
I have a template with a sheet named Home. The template pulls data from
another sheet called work. The sheet home has a range set for the data area but the data from work does not always fill the range area and leaves rows blank. The data area starts at row a4 and the last column is M. The current range is a4:m182, a line of Totals is on row 183. Question: I need to be able to sort the data in 3 ways, alpha, numeric and date order. How do I make the range dynamic to enable me to make the sorts and ignore the blank cells on the template? (Blank cells are cells) Thanks in anticipation Topher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting the absolute range address from a dynamic named range | Excel Programming | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
copying dynamic range based on cell outside of range | Excel Programming | |||
select dynamic range with dynamic start point | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |