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 387 | Reading 2 min | Date 09-07-2024 | Category: Blog

Read more:

Benefits of getting followers on Instagram

Benefits of getting followers on Instagram

The benefits of getting followers on Instagram can vary depending on the goals pursued by the user or business. Let's look at the main advantages that can be highlighted: Advantages of increasing followers on Instagram: 1. Increased social visibility:- Increased popularity: A large number of followers immediately makes an account more visible among other users and can attract additional attention.- Algorithm recommendations: Instagram algorithms may be more likely to recommend accounts with a ...
Views 227 | 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 228 | Reading 2 min | Date 17-12-2024 | Category: Promotion
Read