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

 

[Rameses]

AK

please may you take me thought this step by step

maight it be because of the type of excel file? I wonder if i resave it as a macro enabled file

many thanks

Rameses

 

[VoG]

It has to be a macro enabled file, with macros enabled.

 

[Akashwani]

Hi Rameses,

Yes it does need to be saved as a macro enabled file.
I just save as Excel 97-2007 workbook.

Ak

 

[Rameses]

hi AK

absolutly nothing happened

I just cant work out what I have done wrong

is there anything I need to do after ALT+Q

all i have done is just selected onto sheet 2 but it is blank of data!

hmmm im going to get to the bottom of this lol

perhaps macros are disabled in a macro enabled file?...how could I check this?


Rameses

 

[VoG]

Change something in Sheet1 then check what is in Sheet2.

 

[Akashwani]

Hi Rameses.

alt-F11
Insert
Module
Then copy in my code
alt-Q

Insert
Shapes
(select your shape)
Click the sheet.
Right click the shape
Assign Macro
Click on CopySheet1
Ok

Now click the button

Ak

 

[Rameses]

Hi Ak

All went well until Assign Macro

It opened up a dialogue box with Macro as the title

but in all the drop down boxesit does not have

'CopySheet1'

I therefore typed it in

once I had the shape and clicked on it a dialogue box opened with the following message

Cannot run the 'macro enabled copy lol.xlsm'!copySheet1'. The macro may not be available in this workbook or all macros my be disabled.


Is there a way I can check to see whether Macros are enabled?

many thanks as always

Rameses

 

[Rameses]

Hi Peter

I also tried that but to no avail

How can i check whether i have macros enabled? (even though it is saved as a macro enabled workbook!!)

many thanks

rameses

 

[Akashwani]

Hi Rameses,

Click the Excel icon in the top left corner.
Excel Options (bottom right)
Trust Center
Trust Center Settings
Macro settings
Enable all Macros etc
OK
OK

You will have to do this if you want to use Peter's code or mine.

Ak

 

[Rameses]

Thankyou Ak and Peter

Would you believe that even though the workbook was macro enabled the macros were still disabled

It was on the 2nd option Trust access to the VBA project object model

and

does not work on work computer(as some of the access rights to VBA had been denied) so had to use home computer with open access rights

it works perfectly now

many many thanks for your time and persistence with me

Rameses