And just to add on here, once you have all the data in your third sheet, just
highlight the worksheet, Copy, paste special/values to get rid of your
references...

"Joel" wrote:

Copying the reference is very easy. Describe what type of merging you ae
looking to do? to merge tthe data you are going to need the range of cells
you wantt to copy

If you want to reference 'HH1'!B2:D5 you are talking about an area that is 3
columns wide and three rows long.

if you put in cell A1
='HH1'!B2

Then copy this formula to the range A1:C3 the 9 original cells will show on
the summary sheet. this is a pretty simple operation.

"Sanj" wrote:

tnks, but thats not quite what I expected.
Is there any other merging method other than referencing.


"Joel" wrote:

the format for referencing other worksheets is

='HH1'!B2 use the single ' and the explainattion !
='HH2'!C4



"Sanj" wrote:

Hi,
I have a excel work book that consist of sheets HH1 & HH2
I would like to merge this two to get a summary sheet. I would not like to
cut & past information to Summary sheet.
Can someone help me to do this pls.