All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc