Sheet within a Sheet

[dd]

I have created a frontpage for my excel database which displays records via
a combobox and Index values. I have included a photograph in my worksheet
which displays a photograph of the selected combobox item and I also want to
show the relevant item report below this.

The item reports comprise various .xls workbooks whose paths and hyperlinks
I can refer to via the Index function on the frontpage. The Range comprises
a Worksheet called "Work" and the Cells A2:J7

How do I insert this worksheet range onto my worksheet - I do not see a
worksheet object when I try to Insert-Object?

How about a textbox?

Regards
Dylan Dawson

 

[DD]

I have a worksheet of survey records and a worksheet that allows the user to
select individual surveys details and view the associated photograph.

Each survey has a separate survey report file, also in excel, all reports
contain generic text with very little formatting and they are consistent in
layout they covered over cells A1:J7.

I have set up hyperlinks for the photographs and survey files and I have set
up an image object which opens the photograph in the worksheet. I also want
to be able to bring in the survey report for the selected record into the
worksheet.

How do I import this range into my worksheet on a selective basis, i.e. by
survey?

Dylan Dawson
Scotland


"dd" <dd.dd> wrote in message I have created a frontpage for my excel database which displays records via
a combobox and Index values. I have included a photograph in my worksheet
which displays a photograph of the selected combobox item and I also want to
show the relevant item report below this.

The item reports comprise various .xls workbooks whose paths and hyperlinks
I can refer to via the Index function on the frontpage. The Range comprises
a Worksheet called "Work" and the Cells A2:J7

How do I insert this worksheet range onto my worksheet - I do not see a
worksheet object when I try to Insert-Object?

How about a textbox?

Regards
Dylan Dawson