Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default drop info auto from sheet 1 to 2

how do i get info to automaticly fall onto sheet 2 when working in sheet 1
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default drop info auto from sheet 1 to 2

Try this
='source tab name'!source tab cell address

for example:

='accounts'!d34

This presumes you are pulling data from a different tab within the same
worksheet

--
Sony Luvy


"rabbit" wrote:

how do i get info to automaticly fall onto sheet 2 when working in sheet 1

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
Need a Drop Tab that when selected, auto filters info to a cell!!! Armando Excel Discussion (Misc queries) 1 December 2nd 06 05:39 AM
Need a Drop Tab that when selected, auto filters info to a cell!!! Randy L Excel Discussion (Misc queries) 0 November 29th 06 08:27 PM
Need a Drop Tab that when selected, auto filters info to a cell!!! Armando Excel Discussion (Misc queries) 0 November 29th 06 08:18 PM
Need a Drop Tab that when selected auto filters info to a cell!!! Armando Excel Discussion (Misc queries) 0 November 29th 06 08:18 PM
Need a Drop Tab that when selected auto filters info to a cell!!! Armando Excel Discussion (Misc queries) 0 November 29th 06 08:17 PM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"