Freelance projects

Freelance projects

Create a drop-down list of Excel

Databases & SQL — incorrectly specified categories?

4 USD

Client's review of cooperation with Serhii D.

Create a drop-down list of Excel

4 USD

I 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!

5.0

Sergey Pikalov

Reciprocal Feedback

30 September 2021

Freelancer's review of cooperation with Sergey Pikalov

Create a drop-down list of Excel

4 USD

Super 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.

5.0

Serhii D.

Reciprocal Feedback

30 September 2021

Project translated automatically. Log in or register, to view the original Create outfall lists on the basis of an Excel document from the customer. 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 :)

Proposals 4 Discussions 8

Serhii D.

Winning proposal

38 0

Projects 39
Rating -
Rating 1 134

Budget: 200 UAH Deadline: 1 day

I can help
I can help
I can help
I can help
I can help
I can help

Evgen Shyriaiev

7 0

Projects 7
Rating -
Rating 385

Budget: 200 UAH Deadline: 1 day

Sergey, hello to you!
Ready to help you.
Experience in portfolio.
Can I see your file?

Yuliya Karmazina

22 0

Projects 21
Rating -
Rating 340

Budget: 200 UAH Deadline: 1 day

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

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Kostyantin Shestopalov 28 September 2021

Сергей, можно посмотреть сам файл?

Sergey Pikalov

28 September 2021

Здравствуйте, в через личные сообщения

Serhii D. 28 September 2021

Уточните пожалуйста. Выбирая офис из сриска Вы хотите чтоб в другом выпадающем списке были отфильтрованы данные только из него? Если да какой у вас Office?

Sergey Pikalov

28 September 2021

Добрый день,
Да, все верно есть лист с данными и нужно чтобы на втором листе выпадали данные в таком порядке - офис, отдел и ФИО.
Естественно конечный результат (ФИО) должны выпадать только те которые относятся к выбранному офису и отделу.

Как я писал через оффсет не работает после закрытия файла, через диапазон с именами не задалось у меня + стоит учитывать, что исходные данные постоянно будут автоматически обновляться

Serhii D. 28 September 2021

Removed by moderator

Sergey Pikalov

28 September 2021

Office 365 proplus - 1908

Serhii D. 28 September 2021

Office 365. Не знаю какие у Вас данные, и как должно быть в итоге, так как не видел файла. Но в Вашем офисе есть замечательная функция FILTER. Возможно это будет решением. Хотя 1908 тут не знаю имеете ли её

Vladimir Sokolets 28 September 2021

дык макросом выбирать, который срабатывает на изменение ячейки листа, а в ячейку выпадающий список, который кстати можно тоже макросом обновлять если данные изменились... можно, конечно, через динамические диапазоны, но там мороки больше

Add Comment

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 15 proposals 31 July

Not specified
Construction of an automatic scheme for the movement of goods and monetary flows

33 proposals 30 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 41 proposals 27 July

178 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Sergey Pikalov
Kramatorsk, Ukraine
ФОП Коваленко Рита

Projects 4
Rating -
Rating 64

Sergey Pikalov

Serhii D.

Serhii D.

Evgen Shyriaiev

Yuliya Karmazina

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Construction of an automatic scheme for the movement of goods and monetary flows

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Development of an analytical system with a dashboard