Create a drop-down list of Excel
4 USD Data that are available in the general list and are automatically updated (PQ):
Name of office, department, name and name, office
On the other list should be the possibility to choose the office, the department, the name of the person (variants only from this office), the position is automatically drawn.
I tried to perform through OFFSET, but after opening/closing the data check doesn’t work.
The second option through the names, but the problem is that if you save the range, after updating the contact list they will not match the required cells.
If you know how to solve the problem, I am ready to cooperate 🙂
Client's review of cooperation with Serhii D.
Create a drop-down list of ExcelI am very pleased with the result of Sergey’s work in Excel.
This specialist took for a complex work that is solved by macros, which was not suitable for me as the document was planned to be used in the browser version.
In general, Sergey decided this with the help of multi-page formulas, all this time he carefully explained his steps and was really involved in the process with interest.
I recommend Sergey as a responsible executive!
Freelancer's review of cooperation with Sergey Pikalov
Create a drop-down list of ExcelSuper is!! I have long not been so pleased with the work done. I strongly recommend. With Sergey there was absolutely no problem, everything was quickly clear and clear.
-
Winning proposal1 day4 USD
1134 38 0 Winning proposal1 day4 USD
I can help
I can help
I can help
I can help
I can help
I can help
-
1 day4 USD
397 7 0 1 day4 USD
Sergey, hello to you!
Ready to help you.
Experience in portfolio.
Can I see your file?
-
1 day4 USD
345 22 0 1 day4 USD
Hello to you. Please send the file. I have a lot of experience with Excel. You need to read the file immediately. I will be happy to cooperate. turn to
-
Сергей, можно посмотреть сам файл?
-
Sergey Pikalov ФОП Коваленко Рита
Здравствуйте, в через личные сообщения
-
Уточните пожалуйста. Выбирая офис из сриска Вы хотите чтоб в другом выпадающем списке были отфильтрованы данные только из него? Если да какой у вас Office?
-
Sergey Pikalov ФОП Коваленко Рита
Добрый день,
Да, все верно есть лист с данными и нужно чтобы на втором листе выпадали данные в таком порядке - офис, отдел и ФИО.
Естественно конечный результат (ФИО) должны выпадать только те которые относятся к выбранному офису и отделу.
Как я писал через оффсет не работает после закрытия файла, через диапазон с именами не задалось у меня + стоит учитывать, что исходные данные постоянно будут автоматически обновляться -
deleted by moderator
-
Sergey Pikalov ФОП Коваленко Рита
Office 365 proplus - 1908
-
Office 365. Не знаю какие у Вас данные, и как должно быть в итоге, так как не видел файла. Но в Вашем офисе есть замечательная функция FILTER. Возможно это будет решением. Хотя 1908 тут не знаю имеете ли её
-
дык макросом выбирать, который срабатывает на изменение ячейки листа, а в ячейку выпадающий список, который кстати можно тоже макросом обновлять если данные изменились... можно, конечно, через динамические диапазоны, но там мороки больше
-
Current freelance projects in the category Databases & SQL
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 14 hours 10 minutes back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 5 days 13 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 9 days 7 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 11 days 11 hours back ∙ 61 proposals |
Kramatorsk