how do i get info to automaticly fall onto sheet 2 when working in sheet 1
S sony654 Jul 4, 2008 #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
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
