Link Worksheets in the same Workbook

[Rameses]

Hi all

Please may you assist with this one

I would like to link Sheet 1 to Sheet 2 (Both sheets are in the same workbook)
so that sheet 2 displays the selected data of sheet 1

Also I dont want to show all of the data from sheet 1 ie. I only want to show everything in columns A,D, E & J only(from sheet1) into sheet 2 as A,B,C & D.

I would like to be able to make change in sheet a only but for these changes to be seen immediately in sheet b (master and slave scenario)

many thanks

Rameses

 

[Akashwani]

Hi Rameses,

I'm pleased that you have been able to get this resolved.
Personally, I think that you should use Peter's code to achieve what you need, he really knows his Excel, unlike myself

I don't know where you are in the world, but for me it's Good Night.

Ak

 

[Rameses]

Cheers AK

am UK so nearly bedtime for me lol

many thanks once again

Rameses