The format is not the same on each page


"Billy Liddel" wrote:

Assuming that the format is exactly the same on each sheet then the offset
function will do the job
Place the following on sheet1 B7
=OFFSET(Sheet2!A7,0,B$6)

B6 contains the month you want to call from 1 to 12. Copy as required.

Regards
Peter A

"dolson" wrote:

I have a B/S on one page and the data resides on another page for all 12
months.
By changing the month number on the Balance Sheet (B/S) it pulls the data
for that period to the apporpriate accounts.