Autocomplete across several worksheets in the same workbook?

C

Colin Hayes

Hi

I have a workbook of 12 worksheets. I use autocomplete regularly.

The problem is that it only looks for autocomplete in the same
worksheet. When I go on to worksheet 2 , I have to start again. It would
be nice if the autocomplete function carried on over into the second
worksheet , so that it could autocomplete using the entries made on
worksheet 1. Or indeed on any of the others...

Is it possible to so this? Or does anyone know of an addin that would
help? I did search on the net but found nothing so far.

Any advice gratefully received.



Best Wishes
 
G

Gord Dibben

Colin

Autocomplete works only on a column in a worksheet

And then in most cases, only on contiguous data below or above the insertion
point.

There is no autocomplete function across workbsheets or columns of one sheet.

Do not know of any add-ins available.


Gord Dibben MS Excel MVP
 

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

Linking Formulae Across a Workbook 2
Combine Several Worksheets within a Workbook 1
Code to format cells on several worksheets 2
How to apply macro across multiple worksheets within a workbook 4
Linking worksheets in the same workbook by names not cells 1
Graphing data from multiple worksheets in same workbook 1
copying & incrementing formulae across open worksheets 4
Inserting Columns Across Multiple Worksheets 4

Top