drop info auto from sheet 1 to 2
 

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

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