Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,101
Default How do I autopopulate data in excel?

I am creating a workbook that has 20 worksheets in it. I need some cell data
from the first worksheet to auto-populate in various cells on the other
worksheets. Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default How do I autopopulate data in excel?

Hi
use a formula such as
='sheet1'!A1

--
Regards
Frank Kabel
Frankfurt, Germany

"Mike" schrieb im Newsbeitrag
...
I am creating a workbook that has 20 worksheets in it. I need some

cell data
from the first worksheet to auto-populate in various cells on the

other
worksheets. Is this possible?


  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default How do I autopopulate data in excel?

hi,
yes. you could use something like
=sheet1!cellAddress

-----Original Message-----
I am creating a workbook that has 20 worksheets in it. I

need some cell data
from the first worksheet to auto-populate in various

cells on the other
worksheets. Is this possible?
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel Filter and Autopopulate Philip Excel Worksheet Functions 3 March 30th 09 03:42 AM
Excel Drop Down/ Autopopulate Philip Excel Worksheet Functions 5 March 27th 09 10:48 PM
Using Excel to autopopulate color.. Johnny Levy Excel Discussion (Misc queries) 3 September 29th 08 11:13 PM
Autopopulate row number in A2 IF data is entered in B2. Cassie Excel Discussion (Misc queries) 7 July 28th 08 09:28 PM
Autopopulate a drop down list in Excel How to autopopulate a drop down list Excel Discussion (Misc queries) 2 July 31st 07 11:26 AM


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"