Pulling Data in Excel

K

kitkatq

I want the information that is associated with a number to be placed in cells
next to that number by pulling the information from any worksheet that may be
existing in the workbook in excel (but that info is only being inputted
once). Any help?
 
K

kitkatq

On Sheet 1 cell A6 has a number SK-1, on Sheet 4 the number A6 is inputted at
a later time along with information in the cells next to it (like B7, B8...).
On Sheet 1 I want the B7, B8 info to automatically appear. The thing is, I
don't know when SK-1 is going to be inputted and it could be in any cell on
any Sheet #.... does this make sense....
 
Top