Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 02:34 AM posted to microsoft.public.excel.newusers
la90292
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

I want to create a telephone call list from my customer list. I only want to
view the records with the data in these columns only; CODE (A7), ACCOUNT
(B7), BUYER (C7), ADDRESS (D7), CITY (E7), ST (F7), ZIP (G7), TEL (H8), FAX
(J8), NOTES (M8). For instance, I do not need the EMAIL column on my call
list.

I would like new list with the columns as follows sorted by ST, CITY, ZIP,
ACCOUNT:
CODE, ACCOUNT, BUYER, TEL, ADDRESS, CITY, ST, ZIP, TEL, FAX, NOTES

Is there a faster/better way to do this rather than cut and paste each time?

Thanks,
victor




  #2   Report Post  
Old February 3rd 06, 11:17 AM posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

It seems that the best way is to use autofilter.

Highlight the column headers (CODE, ACCOUNT etc) that you want to work
on (Alternatively highlight all headers). Then select from the main
menu data--autofilter. That will display little arrows next to each
header.

If you click on such an arrow Excel pops up a little listbox with all
the entries in that column (unique and sorted) plus a couple of extra
options. One is "nonblanks". Choose that and Excel will only show lines
where that column has an entries. If you continue to do that on other
columns you constantly narrow down your selection because from the
subset mentioned above it will only show the ones that meet the second
selection etc. You can sort that selection by highlighting the lines
displayed (by clicking on the row headers).

If you want to display the full set again, the quickest way is to
select the headers and select data--autofilter which will turn off
autofilter. You can then start all over as described above.

Hans

  #3   Report Post  
Old February 3rd 06, 11:25 AM posted to microsoft.public.excel.newusers
Roger Govier
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

Hi

One way
Create another sheet. Assuming this data is on Sheet1, then on Sheet2

A7=Sheet1!B7 B7=Sheet1!A7 C7=Sheet1!C7
D7=Sheet1!H8 E7=Sheet1!D7 and so on
Then, mark the range of data on Sheet 2 and Sort by Column H, then
column G then Column I
If you do put these in Row 7 (I only chose that as that was the row in
Sheet1), put a series of headers in Row 6.
Mark the range of row 6 and DataFilterAutofilter
Use the dropdown to select any given Account, or any Zip etc.

--
Regards

Roger Govier


"la90292" wrote in message
m...
I want to create a telephone call list from my customer list. I only
want to view the records with the data in these columns only; CODE
(A7), ACCOUNT (B7), BUYER (C7), ADDRESS (D7), CITY (E7), ST (F7), ZIP
(G7), TEL (H8), FAX (J8), NOTES (M8). For instance, I do not need the
EMAIL column on my call list.

I would like new list with the columns as follows sorted by ST, CITY,
ZIP, ACCOUNT:
CODE, ACCOUNT, BUYER, TEL, ADDRESS, CITY, ST, ZIP, TEL, FAX, NOTES

Is there a faster/better way to do this rather than cut and paste each
time?

Thanks,
victor





  #4   Report Post  
Old February 3rd 06, 12:44 PM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

Columns can be hidden by highliighting them and doing Right-click
Hide.......... Then, insert a new row as row 1, then number the rows in the
order you wish them to be from left to right.......then you can sort
Horizontally by doing Data Sort Options and checking the Sort Left to
Right option............then delete row 1 if desired............

Vaya con Dios,
Chuck, CABGx3



"la90292" wrote:

I want to create a telephone call list from my customer list. I only want to
view the records with the data in these columns only; CODE (A7), ACCOUNT
(B7), BUYER (C7), ADDRESS (D7), CITY (E7), ST (F7), ZIP (G7), TEL (H8), FAX
(J8), NOTES (M8). For instance, I do not need the EMAIL column on my call
list.

I would like new list with the columns as follows sorted by ST, CITY, ZIP,
ACCOUNT:
CODE, ACCOUNT, BUYER, TEL, ADDRESS, CITY, ST, ZIP, TEL, FAX, NOTES

Is there a faster/better way to do this rather than cut and paste each time?

Thanks,
victor




  #5   Report Post  
Old February 3rd 06, 04:27 PM posted to microsoft.public.excel.newusers
la90292
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

Thanks for all the suggestions...genius!

One more question, how do you unhide the columns that you hide?

Thanks again!

victor

CLR wrote in message
...
Columns can be hidden by highliighting them and doing Right-click
Hide.......... Then, insert a new row as row 1, then number the rows in

the
order you wish them to be from left to right.......then you can sort
Horizontally by doing Data Sort Options and checking the Sort Left

to
Right option............then delete row 1 if desired............

Vaya con Dios,
Chuck, CABGx3



"la90292" wrote:

I want to create a telephone call list from my customer list. I only

want to
view the records with the data in these columns only; CODE (A7), ACCOUNT
(B7), BUYER (C7), ADDRESS (D7), CITY (E7), ST (F7), ZIP (G7), TEL (H8),

FAX
(J8), NOTES (M8). For instance, I do not need the EMAIL column on my

call
list.

I would like new list with the columns as follows sorted by ST, CITY,

ZIP,
ACCOUNT:
CODE, ACCOUNT, BUYER, TEL, ADDRESS, CITY, ST, ZIP, TEL, FAX, NOTES

Is there a faster/better way to do this rather than cut and paste each

time?

Thanks,
victor








  #6   Report Post  
Old February 3rd 06, 05:08 PM posted to microsoft.public.excel.newusers
Pete
 
Posts: n/a
Default HOW TO VIEW SPECIFIC COLUMNS for A CALL LIST?

Highlight the columns either side of those that are hidden and click
Format | Column | Unhide.

Hope this helps.

Pete



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add one column if 2 other columns have a specific value jettp Excel Worksheet Functions 2 January 27th 06 06:55 PM
View only items in the left column that have X's in right columns townieflo Excel Discussion (Misc queries) 2 November 23rd 05 04:12 PM
Select specific numbers from a list based on position judoist Excel Discussion (Misc queries) 1 November 21st 05 04:19 PM
Filtered list & maximum no columns problem claytorm Excel Discussion (Misc queries) 0 August 24th 05 10:52 AM
Use list options to hide columns G_Chem Excel Discussion (Misc queries) 5 June 25th 05 06:05 AM


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017