Hi ,
I had an existing workbook which have three sheets in it.Sheet1 is the summary of sheet2 & sheet3.
In Sheet1 , i have placed a formula Sheet2!B33 in a row.The value is retrived as per required.In sheet2 i dont know how many rows the query will retrive.I want to format sheet1 in such a way it picks the value from sheet2 automatically.
for eg
Sheet1
Sheet2!B33
Sheet2!B34
Sheet2!B35
Regards,
Anita