将多张纸中的任务导入到一张纸中 [英] Importing tasks from multiple sheets into one sheet

问题描述

我很高兴在这里得到专家的帮助...

I would be happy to get the help of the experts here…

请检查此电子表格: https://docs.google.com/spreadsheets/d/1pyog50iENw2p7X6Tz-gCgL301 E-gQrqM/edit

Please check this spreadsheet: https://docs.google.com/spreadsheets/d/1pyog50iENw2p7X6g301gtLdh9TkWzCvvDa8-E-gQrqM/edit

我们的公司与电子商务企业的买卖双方打交道.对于每个卖方，我们打开一个工作表，在该表中以卖方1"，卖方2"和卖方3"中所示的相同方式管理与其交易相关的任务.这样，我们可以根据对业务表现出兴趣的相关买家轻松地查看此特定交易的所有相关任务.

Our company deals with buyers and sellers of eCommerce businesses. For each seller, we open a sheet where we manage the relevant tasks for his deal in the same way shown in the sheets "seller 1", "seller 2" and "seller 3". This way, we can easily see all the relevant tasks for this specific deal based on the relevant buyers that show interest in the business.

在这里我需要您的帮助:

Here is where I need your help:

我想创建一个诸如摘要"表之类的表，该表将向我展示我们为所有卖方完成的所有任务.换句话说，在此工作表中，将显示在所有卖方工作表中找到的任务数据.还要提一下，每隔几天，我们可能会在此电子表格中添加一个新卖家/一个新卖家，因此，重要的是我们能够在添加新卖家之后轻松地更新摘要表，而无需很多手工工作.

I want to create a sheet such as the "summary" sheet that will show me all the tasks we have for all sellers. In other words, in this sheet, the data of the tasks that are found in all the seller sheets will be shown. It is also important to mention that every few days, we may add a new seller / new sellers to this spreadsheet, so it is important for us to be able to update the summary sheet with ease once new sellers are added and without the need for lots of manual work.

您对实现此目标的最佳方法有何建议?

Do you have any suggestions on the best way to achieve this goal?

推荐答案

尝试:

=ARRAYFORMULA(QUERY({SPLIT(
 {"Seller 1♥"&Seller1!A3:A; 
  "Seller 1♥"&Seller1!A3:A;
  "Seller 1♥"&Seller1!A3:A;
  "Seller 2♥"&Seller2!A3:A;
  "Seller 2♥"&Seller2!A3:A;
  "Seller 2♥"&Seller2!A3:A;
  "Seller 3♥"&Seller3!A3:A; 
  "Seller 3♥"&Seller3!A3:A;
  "Seller 3♥"&Seller3!A3:A}, "♥"), 
  {Seller1!B3:F;
   Seller1!G3:K;
   Seller1!L3:P;
   Seller2!B3:F;
   Seller2!G3:K;
   Seller2!L3:P;
   Seller3!B3:F;
   Seller3!G3:K;
   Seller3!L3:P}},
 "where Col3 is not null", 0))

这篇关于将多张纸中的任务导入到一张纸中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！