AutoComplete across tabs

C

C.Bradford

I am filling out annual financial information and seperating each month onto its own tab, but AutoComplete will not recognize names on different tabs so each month I have to retype everything. Is there a way to get AutoComplete to see the names on other tabs or names below the active cell so I could copy/paste the names at the bottom of the worksheet and delete them when I'm finished.



Thanks in advance.
 
D

Debra Dalgleish

You could paste the list of items at the bottom of the column on the new
month sheet.

Then, select all the cells above the pasted list
Type: =""
Hold the Ctrl key, and press the Enter key
Select the first cell in which you want to enter an item from the list

When you've entered all the items, clear the cells that contain ="",
and clear the pasted list.
 
Top