Posted to microsoft.public.excel.programming

robz

external usenet poster

Posts: 1

hi i reall need help with autofill

ok i have a File.. preety big that has tabs like these on the bottom ..
Z1, Z2, Z3, Z4.. all the way too Z979

Now i have a summary sheet in the Fron where i have this in the cell:
=Z1!A1
=Z2!A1
=Z3!A1

...

now is there a way i can auto fill this all way down.. someone pleas
help.. i need to get this done than

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AutoFill	carl	Excel Worksheet Functions	3	May 22nd 07 07:06 PM
AGAIN i shall ask. Reall need this bad	ixlr84fun	Excel Discussion (Misc queries)	0	December 31st 05 01:10 AM
Autofill until	uberathlete	Excel Discussion (Misc queries)	1	November 9th 05 06:01 PM
Autofill	sisco98	Excel Worksheet Functions	1	June 28th 05 01:30 PM
Autofill: Need to autofill one week block, (5) weekday only into cells.	dstock	Excel Discussion (Misc queries)	1	June 17th 05 08:21 PM

All times are GMT +1. The time now is 04:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us