Making a large spreadsheet more manageable

N

Nikki C

I have a rather LARGE spreadsheet in Excel 2000 that I add
information to every day. The information is divided up
by section, and rather than using the Find feature to find
the area where I need to enter the information, it would
be nice to be able to have drop-down selection lists to
find the information needed, or an easy way to enter the
information so it will pop in to where it needs to go.
Does anyone know an EASY way of doing this? It is a
spreadsheet for tracking invoices, subtotaled by project
number.
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals in very large datasets 5
Automatically Linking New Spreadsheets to Master File 1
Using a Max Subtotal a Formula 5
HI!Need to make Cell formula change for each Pg Break in a Print T 1
Breaking up one LARGE table into several smaller ones 9
Formula to display last entry in a column populated with #N/As 4
Custom Form in Word 2010 - Help! 1
compare information from two spreadsheets or excel sheets 1

Top