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.