Skip to Content
0
Nov 30, 2006 at 09:50 AM

Workbooks

27 Views

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