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.
-
1134 38 0 I can implement the best solution in Excel. Reviews on such work are in the portfolio.
-
397 7 0 Lord, heal to you!
I can help. He did the same.
The time determined even low, taking into account the experience (in Portfolio).
-
2864 72 0 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.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 2 days 14 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 3 days 6 hours back ∙ 10 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 5 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days 6 hours back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 7 days 15 hours back ∙ 14 proposals |