Question description:
This user has given permission to use the problem statement for this
blog.
i want my spreadsheet to update stocks on the stocks column automatically from links provided in column and display the stock status on third column.
Solved by E. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/01/2018 - 05:30
good day
Excelchat Expert
15/01/2018 - 05:30
how may i help you today
User
15/01/2018 - 05:30
i need to update my stock report from weblinks as above
Excelchat Expert
15/01/2018 - 05:31
you need to make use of the query function in excel 2016
Excelchat Expert
15/01/2018 - 05:32
are you familiar with the feature?
User
15/01/2018 - 05:32
no
Excelchat Expert
15/01/2018 - 05:33
ok
Excelchat Expert
15/01/2018 - 05:33
open up your excel 2016
Excelchat Expert
15/01/2018 - 05:34
go to data ribbon
User
15/01/2018 - 05:34
this is what i want
User
15/01/2018 - 05:35
can u be able to see that?
Excelchat Expert
15/01/2018 - 05:36
yes
Excelchat Expert
15/01/2018 - 05:36
i can
Excelchat Expert
15/01/2018 - 05:37
are you using google sheets or excel for this?
User
15/01/2018 - 05:38
the links are on column A
Excelchat Expert
15/01/2018 - 05:38
ok
User
15/01/2018 - 05:39
Any changes lets say reduction in stock in that link should update Column B and C
Excelchat Expert
15/01/2018 - 05:39
so you are referring to multiple links
User
15/01/2018 - 05:39
yeah
Excelchat Expert
15/01/2018 - 05:39
ok let me see
Excelchat Expert
15/01/2018 - 05:40
write a sample html
Excelchat Expert
15/01/2018 - 05:40
website
Excelchat Expert
15/01/2018 - 05:40
under the link coloumn
User
15/01/2018 - 05:43
go ahead
Excelchat Expert
15/01/2018 - 05:43
ok one more question
Excelchat Expert
15/01/2018 - 05:44
under this link
Excelchat Expert
15/01/2018 - 05:44
is the stock available inside a table or list?
User
15/01/2018 - 05:45
open that link..u will see the stock am reffering to
User
15/01/2018 - 05:45
put up a formula that updates my column B
Excelchat Expert
15/01/2018 - 05:47
its not showing any stock
Excelchat Expert
15/01/2018 - 05:47
says seller not available
Excelchat Expert
15/01/2018 - 05:47
item no longer available
User
15/01/2018 - 05:48
where is your formula?
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.
