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

J

Joel Bernard

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

Richard

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

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
 
G

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
 

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

One note creating multiple tabs when collaborating? 0
Auto Populate One Pages from spreadsheet 0
How to automate update on weekly reports spreadsheet 0
Photo rotation within a shape - Microsoft 2013 0
Auto populate value from one task to another in MS PROJECT 0
Consolidation Table from Different Excel Tabs with Different Format 1
Problem with printing a word document containing a table 0
Auto Fill Word Documents 4

Top