Pulling data from closed files

[bhasan01854]

Helps when updating a particular report of the same format, but for different periods of time.

How to use:

Download all the necessary data in the format of tables from which the report is built, and put them in a separate folder. Open the final file in which the data is collected.





We put a link to the cells from the previously downloaded data.



If the report does not change, we put a link to a specific cell.





The data changes - we use the VLOOKUP function, which works even if you refer to a closed file.





Now, when updating a report, you just need to replace the data in the folder with the current data, open the final report and update the links in it.

Pulling old texts by groups and campaigns to new ones
Helps when comparing files - for example, office 365 database for old and new texts from an account. Rearranging texts manually is boring and tedious, here the CONCATENATE and VLOOKUP functions will help.





To do this, we add an additional column to the file with the old and new texts. Then, using the IF function, we assign a number to each line.





Let's create another additional column. Using the CONCATENATE function, we combine the campaign name, group name, and row number.