Project translated automatically. Log in or register, to view the original The following task: There are tables with products in the form of reports: reports for 21 and 22 years, it is necessary to add reports for 23 years, i.e. Under each product add the same format in 23 years. How to do this? One way: separate all product lines in 22 years, then copy and insert cells under 22 years, all numbers 22 change to 23 and move further. The total number of products is 150 pieces. The same work should be done for the groups of these products: the total number of groups 30. Data for 21 years must be hidden: grouped. Third task: There are promotions: history It is necessary to place a note on each product in the table that during this period there was a stock: For example, the product 1 in February had a stock in the store 1, then we enter the cell 1 under the column of February the word PROMO The total number of stores = 5. History is needed for 21 / 22 / 23 years. It is ideal if there are ideas about how to fill the table with the formula method rather than manually, but this is the choice of the artist already.

Update #1 from 4 September 2022

Only 2 tables. 1 table with 150 products. Table 2 with 30 categories. It is necessary to add lines to each product and category. Log in or register, to view the original

Update #2 from 4 September 2022

Explanation of what is needed: 22 years and copying. Then we choose the place to put and put in: or Cntr + Shift + = We have two identical statistics. Let us leave one unchanged. in the second bottom we change all the value 22 (this year is 22 to 23) And the work is done. 150 products, that is. Copy the data 150 times. Then do the same for the group + 30 times. • • • • • • • • • We filter the group by F-Group and let us know that the group B873 is a group of shares in the promo list and has a position 1 (in the promo list) After filtration we get all the products of category B873, then filter by year and by store and in each column in this category we enter the word PROMO with the method COPY-PASTE for the month January. So we have updated all the promo data together. Log in or register, to view the original

Proposals 4 Discussions 2

Roman G.

3 0

Projects 3
Rating -
Rating 182

Budget: 900 UAH Deadline: 5 days

The task is fully understood. I can start today. The deadline is set with the stock. I always do faster.

Oleksandr Nazarov

Winning proposal

15 0

Projects 16
Rating -
Rating 788

Budget: 900 UAH Deadline: 2 days

I make the formulas of the macros, you have to discuss what you eventually want to get filled leaves or template that does it yourself, please contact.

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

Current freelance projects in the category Data Parsing

Collection of phone numbers from olx.pl

33 proposals 11:02

Not specified
Autoria Parser

70 proposals 2 August

Not specified
Reddit API

Web Programming 29 proposals 30 July

Not specified
Website parsing, bypassing Akamai protection

Python 47 proposals 30 July

Not specified
Парсинг маркетплейсу

Bot Development 37 proposals 30 July

38 USD

Alex Alex
Estonia

Projects 67
Rating -
Rating 657

Alex Alex

Oleksandr Nazarov

Roman G.

Oleksandr Nazarov

Proposals are currently absent

Current freelance projects in the category Data Parsing

Collection of phone numbers from olx.pl

Autoria Parser

Reddit API

Website parsing, bypassing Akamai protection

Парсинг маркетплейсу