Not sure how to tackle this

  • Thread starter Thread starter colinmunnelly
  • Start date Start date
C

colinmunnelly

Need some guidance on this. The problem is:

I have a sheet of approx 3000 names (Say in column A) I then have
another sheet with the same 3000 names but in column B are names
inserted alongside the originals in column A. This spreadsheet or list
is a christmas card list and so there will be approx 30 people placing
there names alongside the customers in column A so this will have to be
done several times, therefore i think i would have to place additional
names in cells. Not sure of the way to start tackling this.
Any help would be really appreciated.
 
What are you trying to do?

Are you trying to find out who, from your 30 staff, what to send xmas
card to which of your 3,000 customers/clients/contacts etc?

What do you want to do with the lists? What do the names represent?

Chrissy.


colinmunnelly wrote
 
yes i need to find out from all the 30 staff who they would like to send
an xmas card to from the 3000 list of names
 
The easiest way would be to have your list of 3,000 names in a column
and the list of 30 staff names in a row along the top of the same sheet.
If you format the staff names so the text is on its side and make the
columns narrow all 30 staff will fit on one screen width.

So, cells B1:AE1 will contain staff names and will be formatted so the
text is on the side and will be narrow columns. Cells A2:A3001 will
contain the 3000 names and will be wide enough to show all names
(use auto fit). Go to cell B2 and freeze panes (menu Window --> Freeze
Panes).

Each staff puts an X in any cell in their column for anyone whom they
wish to give a card to.

Hope this helps.

Chrissy.
 
Back
Top