bosses always want the impossible

jajames83

New Member
Joined
Dec 2, 2005
Messages
1
I need to created a flat database which isn't too difficult in excel. But my boss decided to add the condition of being able to look at each record of the database (ie each person's info) seperated by pages. Is there any way of accomplishing this.? I told him that we needed a database program most likely filemaker (we use macs) but he is adamant about using excel probably becuase it's all that he knows. I'm just starting this job and I really don't know how to do what he is asking of me, and I don't want to him to view me as incompetent. Is there any way of viewing the same data in two ways and being able to print it in excel?

Thanks
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Travis

Well-known Member
Joined
Feb 26, 2002
Messages
1,711
Welcom to th eBoard!

Read help on Pivot Tables. I think that should do what you want.
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
From Travis

Read help on Pivot Tables. I think that should do what you want.

I agree. Simply use each person for a page in your PT.

lenze

NOTE: Your boss will think you're a genius. Tell him you worked on it for hours, though in reality probably only 15 minutes
 

Watch MrExcel Video

Forum statistics

Threads
1,118,116
Messages
5,570,273
Members
412,316
Latest member
JabirS
Top