Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select Subset of Rows/Cols
I was given an Excel Spreadsheet (v2003) and asked to let the user print
subsets of data. Is there a way to print out a subset of columns and rows (like using a SQL statement)? SELECT Name, Age FROM xxx WHERE State = 'CA' For example: Given: Name State Age Height Weight Bob CA 23 5'9" 160 Sam CA 26 6'0" 195 Bill NV 44 5'8" 170 Curt MN 35 6'2" 210 John CA 38 5'11" 200 Print: Bob 23 Sam 26 John 38 I am somewhat familiar with Macros (although not Excel) and SQL. It would also be alright just to copy the data to a new page. Any help would be appreciated. Thank you, Joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select Subset of Rows/Cols
Look into AutoFilter with Custom Views.
-- Regards Dave Hawley www.ozgrid.com "Joe Thompson" wrote in message ... I was given an Excel Spreadsheet (v2003) and asked to let the user print subsets of data. Is there a way to print out a subset of columns and rows (like using a SQL statement)? SELECT Name, Age FROM xxx WHERE State = 'CA' For example: Given: Name State Age Height Weight Bob CA 23 5'9" 160 Sam CA 26 6'0" 195 Bill NV 44 5'8" 170 Curt MN 35 6'2" 210 John CA 38 5'11" 200 Print: Bob 23 Sam 26 John 38 I am somewhat familiar with Macros (although not Excel) and SQL. It would also be alright just to copy the data to a new page. Any help would be appreciated. Thank you, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF appearing when cells,rows,cols are all protected | Excel Discussion (Misc queries) | |||
Where's a Questionnaire, 6 headed cols., 5 rows in landscape | Excel Discussion (Misc queries) | |||
importing rows to cols | Excel Worksheet Functions | |||
How to enter symbols for subset or element of a subset in Excel? | Excel Worksheet Functions | |||
Cond Format:re color 2 cols, skip 2 cols | Excel Worksheet Functions |