The Excel
There is a table in the Excel with a list of products.Each product belongs to the category, description, measurement unit, code.At this point, each customer looks at this table and, contrary to the desired goods, inserts the required amount.Thus, we receive lists of goods from all customers.We summarize the same goods in 1 table.We make a common order, then we have to look again who ordered how much, etc.M and td.In general, a lot of fiber, which is of course the formulas, can be filtered, but you want to make it a little easier.Therefore you need:
1) Make a convenient table for customers:
- the navigation menu to the left by categories, when you click on the category, the goods are displayed only in this category;
- list of goods: first goes the name, then the description, then the checkbox (if he put a gallon in the checkbox, then the whole line to make a little different color (this is already secondary) and there is a gallon with a measurement unit to enter the quantity, as well as a line for the possibility of commenting (possibly the customer will be interested in a specific color or taste)) and finally the code.- menu, name, product description, codes to protect against changes.- when the customer has chosen everything you need, make the opportunity to view the entire table of goods as a whole and check the amount and everything else.- also make it possible for the customer to arbitrarily enter the product that he wants, but was not on the list, and quantitatively.The file for us:
We receive these files from customers and form a general need in the goods.- We also have the navigation menu on the left by categories and the ability (button) to see the general list.The list of goods itself: name, description, code, total number, number of customer number 1, number of customer number 2, etc.- arbitrary goods (which the customer inserts himself) can be formed separately in the table: name, number and who the customer.
-
5 days101 USD
1138 38 0 5 days101 USD
I can implement the best solution in Excel. Reviews on such work are in the portfolio.
-
7 days113 USD
397 7 0 7 days113 USD
Lord, heal to you!
I can help. He did the same.
The time determined even low, taking into account the experience (in Portfolio).
-
1 day23 USD
2906 72 0 1 day23 USD
It may be so, and it may not be so ;) - with the user forms. Let’s write and talk. Prices and deadlines after discussion. It can be 1000, it can be 5000.
I have been working with VBA since 2011.
-
Это Excel или Гугл таблица?
-
Excel
-
Приложили бы текущий файл Excel или пример такого файла + пример желаемого результата в графическом виде
-
Current freelance projects in the category Data Processing
Creation of an Excel file for uploading products to the website.It is necessary to create an Excel file and fill it with the data we provide, making the file such that it can be uploaded to the website. Similar to Rozetka, WordPress, Prom, and so on. About 100 items. Data Processing, Technical Documentation ∙ 5 hours 35 minutes back ∙ 24 proposals |
Sendpulse specialistGood day. I need help with setting up SendPulse, specifically CRM + Automation. We will discuss the details in private. The project looks approximately like this: 1. Set up a CRM funnel for selling digital products/services. - 6 products. 2. Set up automation after successful… Online Stores & E-commerce, Data Processing ∙ 5 hours 49 minutes back ∙ 4 proposals |
Setting up and optimizing the lawyer's existing social media accountsFor the startup (without launching advertising in the first stage) it is necessary: - to set up a Facebook page, Instagram, a lawyer's Telegram, a lawyer's association page, Meta Business Suite, a Telegram channel, and a consultation route Facebook → Instagram Telegram →… Data Processing, Customer Support ∙ 1 day 2 hours back ∙ 5 proposals |
Assistance with AI, personal social media, and operational tasks 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 ∙ 2 days back ∙ 8 proposals |
Video Content Operator / Data Entry (UBT)
25 USD
Package Import: Receiving source materials (lip syncs, performances) 38 clips of 2 minutes each Audio Overlay: Overlaying an official music track under the lip sync in CapCut or similar software (bulk sound mixing according to a template). Bulk Cutting / Splitting: Mass… Video Processing, Data Processing ∙ 2 days back ∙ 6 proposals |
Slavutich