Using auto-fill to populate a table using data from several tabs

[Joel Bernard]

How do I use the "auto-fill" capability in Excel to fill in a table with cell
data from several tabs?

 

[Richard]

How do I use the "auto-fill" capability in Excel to fill in a table
with cell data from several tabs?

If I understand your question, the answer is you can't. Auto Fill
simply completes a series of data that follows a pattern, in a range
of cells, given a starting series. e.g. entering January and February
in A1:A2, then highlighting this range and dragging the fill handle
down will complete the months of the year.

You'll need a VBA macro to populate a table from data in several
sheets/tabs.

Rgds

­­ 
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo

 

[Gord Dibben]

You can't use autofill across sheets.

Maybe the INDIRECT function can do the trick but more details of how source
sheets are named and what data cells from those are to be filled into the target
sheet.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 08:23:02 -0800, Joel Bernard <Joel