Excel 2002 Autocomplete

D

Drazenka1973

Joined
Jul 12, 2006
Messages
6
Reaction score
0
Hi,
I have a lot of sheets in one excel workbook.
How can I set up excel to do autocomlpete data between sheets in on workbook please?

Best regards

Drazenka
 
Maybe I made this very confused....
What need is like this:
One Workbook with 13 sheets in it.
Every sheet is one month in year.
In every sheet I have to put:
  1. Suplier names
  2. Invoice No
  3. Invoice date
  4. ....
All that data I have to put for each month (sheet) but not in same order.

Is there any way that ms excel do autocomplete for me like when you start to type text on one sheet which was allready there it gives you autocomplete?

Best regards

Drazenka
 
Does it helps a bit?

When entering text values in cells the Auto Completion feature
suggests the value based on your first few letters, and the
corresponding values in the same coloumn.

How can one force Excel to look elsewhere ie. not in cells in the same
row but instead somewhere else on the spread sheet or in another
sheet?
 
Back
Top