SMMSEND.COM - Blog - Creating a mass order using Microsoft Excel
Creating a mass order using Microsoft Excel

Creating a mass order using Microsoft Excel

Download ready-made sample file massorder.xlsx

Instruction:

1. Specify the information in the cells as follows:


A
B
C
D
E
F
1
999
|
https://link.com|=RANDBETWEEN(350;500)=CONCATENATE(A1;B1;C1;D1;E1)

where the following information is specified in the cells:

- A - service id from the list of services on the site,

- B and D - vertical line separating parameters,

- C - link to send likes (subscribers),

- E – the formula for the number of likes (subscribers), where 350 is the lower limit, 500 is the upper limit,

- F – formula for obtaining the total line of the mass order.

2. To create several orders at the same time, you need to create a table like:


A
B
C
D
E
F
1
999
|https://link.com|=RANDBETWEEN(350;500)=CONCATENATE(A1;B1;C1;D1;E1)
2
=A1=B1https://link.com=D1=E1=F1

3. After that, pull the lower right corner of each of the cells A2, B1, D1, E1, F1 down by as many cells, the number of which is equal to the number of orders for this service.

As a result, in column F we get lines of the form:

999|https://link.com|431

999|https://site.com|386

4. Select all cells filled in column F, starting from the first and ending with the last.

5. Right-click on any of the cells and select "Copy" from the menu

6. Paste the received parameters into the field for creating a mass order on the site.

7. Check the absence of empty lines at the beginning and at the end. If empty lines are present, you must remove them.

8. Confirm the order.


Views 310 | Reading 2 min | Date 09-07-2024 | Category: Blog

Read more:

Benefits of boost subscribers in the VKontakte community

Benefits of boost subscribers in the VKontakte community

The benefits of adding subscribers to the VKontakte community can also be very significant, especially if this is done wisely and taking into account all possible risks. Let's look at the main advantages of increasing subscribers to the VKontakte community. Advantages of adding subscribers to the VKontakte community: 1. Increasing social visibility:- Increasing attractiveness: A large number of subscribers makes the community more visible and attractive to other users.- VKontakte algorithms: C...
Views 169 | Reading 3 min | Date 17-12-2024 | Category: Boost
Read
How to properly promote the VKontakte community

How to properly promote the VKontakte community

Promoting the VKontakte community requires an integrated approach and includes several key strategies. Let's look at the basic steps and methods for successful promotion: 1. Community Profile Optimization:- Attractive Name: Use a short and catchy name that reflects the theme of the community and attracts attention.- Description and Information: Develop an informative and attractive description of the community. State the key points and benefits of participation.- Visual: Create an attractive co...
Views 158 | Reading 2 min | Date 17-12-2024 | Category: Promotion
Read