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

 

[VoG]

Hi AK.

I'll await the OP's response re the camera tool before working on your code but that could be changed into a Worksheet_Change event in sheet1.

 

[Rameses]

Hi

Thank VoG I like the Camera tool alot and can see its uses for the end user and for printing butsadly not for this one as i cant filter in the 1 sheet (it takes me back to the original)

Akashwani I will await VoG lol i really wouldnt know where to start!

many thanks

Rameses

 

[Rameses]

VoG

will the code resemble Mike G's from earlier post?

If so I am a bit of a VB novice and have entered the code and clicked on run but it came up with a blank excel spreadsheet and a dialogue box (see earlier post in this thread)

many thanks

Rameses

Ps Akashwani i like the addition of Rameses to spreadsheet hehehe I am grateful for the time it has taken

this one has been puzzling me for a while!

 

[Rameses]

I have been fiddling with =sheet1! then selecting eachcolumn

Im sure the answer is simpler then entering code... but will that that now

 

[Rameses]

Hi Akashwani

I have tried your code but just get a dialogue box which says

'Run-error '9':

Subscript out of range'

Unfortunately I cant provide a screenshot as am in the windows side of my MAc (running parellels) and cant find the print screen button..lol!

any further advice much appreciated.


Any MVP's out htere?

many thanks

rameses

 

[Akashwani]

Hi Rameses,

I'm using Excel 2007, if that makes a difference to how the code works I don't know, sorry.

Ak

 

[Rameses]

hi Akashwani

Im a bit of a novice whne entering code etc I am also using excel 2007

Just to go through the process

I went to the VB icon on the developer toolbar

I clicked on sheet 2 on the left

I then pasted the code into the box on the right
I then clicked on run

lol this time it comes up with a dialogue box which says

Run-time error 1004
Application-defined or object-defined error


I appreciate your help AK any further advice much appreciated

many thanks

Rameses

 

[VoG]

Try this: right click Sheet1's tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Columns("A").Copy Destination:=Sheets("Sheet2").Range("A1")
Columns("D").Copy Destination:=Sheets("Sheet2").Range("B1")
Columns("E").Copy Destination:=Sheets("Sheet2").Range("C1")
Columns("J").Copy Destination:=Sheets("Sheet2").Range("D1")
Application.CutCopyMode = False
End Sub

then press ALT + Q to close the code window.

 

[Akashwani]

Hi Peter,

That works great, as you knew it would

Hi Rameses,
I'm sorry, I should have explained that my code goes in a standard module, you can insert a button to Sheet2 and assign the Macro CopySheet1 to it.

Ak

 

[Rameses]

Hi VoG

Thankyou for this

I have tried this but when i then clickonto sheet 2 it is still blank

Any further advice?

many thanks

Rameses