The list falls in the Excel/Google table with the URL.
The list falls in a table with the text that contains links.(Settings so that the Japanese repeats on all of its goods)
The alternative task:
Only the value falls out of the list, but the word with the links contained in it falls into the neighboring cell.(Settings so that the Japanese repeats on all of its goods)
Implementation on the basis:
I need these solutions in Google tables or Excel tables.Both of these services are online resources.Personal experience :
In Google tables you can add a few links to the word in the cell.On each symbol in the cell you can press conrtl+k and you can assign a new link to it.How many symbols = how many links.I and my friend who +- understands in the axle to realize the intended didn’t come out, but we don’t understand in the macros, so, the usual axle with the teams.Why do I do this:
There is the so-called customer, this is a page in the Google tables, in it I write what you need to take from the supplier and it happens that some position you need to look for from several suppliers, and it's hard for each individual to get out, I want to add the product to the "order", have the opportunity from the customer to immediately run through the links that I will prepare for each product.The Screen:
The screen shows an example, but in this example everything on one page, in practice, the source for the falling list will be on the other page.by P.S
This is my first experience of asking for help at freelance.The cost of work can be discussed depending on the situation and complexity.
Applications 1
-
А с какого боку здесь Excel (указан в заголовке задачи)?
-
В выпадающем списке ссылки работать не будут, вставьте в соседнюю ячейку ВПР, только так.
-
>>На каждый символ в ячейке можно нажать conrtl+k и получится на него назначить новую ссылку.
Ссылок может быть мало, а слово длинное (тык в букву - а ничего нет...). Ссылки невидимы, пока не наведешь на нее указатель. Путь какой-то, мягко говоря, неправильный.
Насколько понял задачу: надо иметь список ссылок, для разных товаров свой (ссылки заранее прописаны). Так почему по буквам, а не видимый список из ссылок или названий поставщиков (со ссылками)?
-
Current freelance projects in the category Data Processing
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 1 day 7 hours back ∙ 7 proposals |
Setting up and updating dashboards in Looker StudioWe have several dashboards created in Looker Studio that pull data from main Google Sheets.Last year, we regularly maintained and updated these sheets; however, the process was later halted, and the specialist who was managing the system no longer works with us. Currently, some… Data Processing ∙ 2 days 4 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 8 days 7 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 9 days 1 hour back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
89 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 10 days 13 hours back ∙ 18 proposals |