**Question description:**

*This user has given permission to use the problem statement for this
blog.*

How to have a cell which contains an image in a spreadsheet show the same data on another spreasheet. So, if I edit the data or image in 1 spreadsheet at any time it would automatically affect the other spreadsheet.

Solved by V. W. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
29/08/2018 - 12:17

Hi

User
29/08/2018 - 12:17

hi

Excelchat Expert
29/08/2018 - 12:17

Welcome to Got it Pro

User
29/08/2018 - 12:18

thanks

User
29/08/2018 - 12:18

so did you understand my question?

Excelchat Expert
29/08/2018 - 12:18

Do you have any excel sheet?

User
29/08/2018 - 12:18

i am using google sheets

Excelchat Expert
29/08/2018 - 12:18

yes..

User
29/08/2018 - 12:18

2 separate spreadsheets (files)

Excelchat Expert
29/08/2018 - 12:19

Please share it with me

Excelchat Expert
29/08/2018 - 12:19

to understand your question.

User
29/08/2018 - 12:21

as a link here?

Excelchat Expert
29/08/2018 - 12:21

Are you there with me?

Excelchat Expert
29/08/2018 - 12:21

Anything is fine

Excelchat Expert
29/08/2018 - 12:21

or download and send it to me

User
29/08/2018 - 12:22

hey

User
29/08/2018 - 12:22

Spreadsheet 1: https://docs.google.com/spreadsheets/d/10mA7uTDFX85OfVZOF4eRYUcWk7Dww-swKjvqMyGZgb0/edit#gid=0

User
29/08/2018 - 12:23

Spreadsheet 2:

User
29/08/2018 - 12:23

https://docs.google.com/spreadsheets/d/1o_ZpCQoqvJ542cYYGsoh_QMuJ55lzPFxE6sg1AnX5x4/edit#gid=0

User
29/08/2018 - 12:23

so i want anything i do in column A of spreadsheet 1 show up on Spreadsheet 2 in real time

Excelchat Expert
29/08/2018 - 12:24

you mean two different workbooks

Excelchat Expert
29/08/2018 - 12:24

not sheets

User
29/08/2018 - 12:24

yes

User
29/08/2018 - 12:25

but for just the first column of 1 always be reflecting on the other

User
29/08/2018 - 12:25

so for example the image of the chair you see in workbook 1, to show up in the same space on workbook 2

Excelchat Expert
29/08/2018 - 12:26

yes. I understand but its not possible

Excelchat Expert
29/08/2018 - 12:26

using formulas

Excelchat Expert
29/08/2018 - 12:26

within the workbook you can do it...

Excelchat Expert
29/08/2018 - 12:26

Anyway please give sometime let me check

User
29/08/2018 - 12:26

ok

User
29/08/2018 - 12:27

also let me know how to do it within the same workbook? and is it possible to hide a sheet in the same workbook from one of the users editing another sheet in that workbook?

Excelchat Expert
29/08/2018 - 12:28

Are you using excel or google sheet?

User
29/08/2018 - 12:29

google sheets

Excelchat Expert
29/08/2018 - 12:29

ok.

User
29/08/2018 - 12:29

i also gave you access both workbooks

Excelchat Expert
29/08/2018 - 12:30

Ok. Hide sheet its possible.

User
29/08/2018 - 12:31

how?

Excelchat Expert
29/08/2018 - 12:31

Right click the sheet name and hide

Excelchat Expert
29/08/2018 - 12:31

Please give me sometime to check ..

Excelchat Expert
29/08/2018 - 12:31

Request you to extend the time

User
29/08/2018 - 12:32

ok

User
29/08/2018 - 12:32

but can i hide it only from specific users?

User
29/08/2018 - 12:32

because when i click hide it hides it from me also

Excelchat Expert
29/08/2018 - 12:32

thats not possible

Excelchat Expert
29/08/2018 - 12:32

yes.

Excelchat Expert
29/08/2018 - 12:33

For your requirement you need to write script not using formulas

User
29/08/2018 - 12:33

i dont understand, what kind of script?

Excelchat Expert
29/08/2018 - 12:34

VBA Macros

User
29/08/2018 - 12:34

so what would be the next step?

User
29/08/2018 - 12:35

and also how can i replicate row A from sheet 1 to row A on sheet 2?

User
29/08/2018 - 12:36

are you there?

Excelchat Expert
29/08/2018 - 12:38

yes..

Excelchat Expert
29/08/2018 - 12:39

Sorry for the inconvenience ! my system got shutdown

Excelchat Expert
29/08/2018 - 12:39

Are you able to see our screen

User
29/08/2018 - 12:39

yes

Excelchat Expert
29/08/2018 - 12:40

There are two sheets

Excelchat Expert
29/08/2018 - 12:40

If I make changes in sheet1 same changes you can see in Sheet 2

Excelchat Expert
29/08/2018 - 12:40

Please check

User
29/08/2018 - 12:40

yes i see

User
29/08/2018 - 12:41

does that work even if its a picture?

Excelchat Expert
29/08/2018 - 12:41

simple link

Excelchat Expert
29/08/2018 - 12:41

Just a minute let me check

Excelchat Expert
29/08/2018 - 12:42

Can you insert one picture in Sheet 1

User
29/08/2018 - 12:43

ok

Excelchat Expert
29/08/2018 - 12:43

Please insert image in Sheet1 - A5 Cell

User
29/08/2018 - 12:43

its not giving me the option

Excelchat Expert
29/08/2018 - 12:43

Oh ok

User
29/08/2018 - 12:43

can you try on one of the spreadsheets i had shared with you?

User
29/08/2018 - 12:44

there is already a picture in workbook 1

Excelchat Expert
29/08/2018 - 12:44

yes. please

Excelchat Expert
29/08/2018 - 12:44

Wait for 2 minutes

Excelchat Expert
29/08/2018 - 12:49

No its not possible for images

Excelchat Expert
29/08/2018 - 12:49

if you give me 5 minutes let me validate using other method

User
29/08/2018 - 12:51

ok

Excelchat Expert
29/08/2018 - 12:53

No it is not possible

Excelchat Expert
29/08/2018 - 12:53

sorry for the inconvience

User
29/08/2018 - 12:53

thank you

User
29/08/2018 - 12:54

and its not possible at all to have same cells appear in another workbook?

Excelchat Expert
29/08/2018 - 12:54

one minute

Excelchat Expert
29/08/2018 - 12:54

try to use this formula to create links

Excelchat Expert
29/08/2018 - 12:54

=hyperlink

Excelchat Expert
29/08/2018 - 12:55

Google sheets am not able to fix it

Excelchat Expert
29/08/2018 - 12:55

excel its very easy

User
29/08/2018 - 12:56

can you see if it works using workbook 2?

User
29/08/2018 - 12:56

and try to copy everything in sheet 1 of workbook A

Excelchat Expert
29/08/2018 - 12:56

due to power cut my wifi switched off so am not able to chat with you now

Excelchat Expert
29/08/2018 - 12:56

its automatically signout

User
29/08/2018 - 12:56

ok then

Excelchat Expert
29/08/2018 - 12:56

sorry

User
29/08/2018 - 12:56

bye

User
29/08/2018 - 12:56

thanks

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*