首页 \ 问答 \ 宏从一个工作表中逐列复制和粘贴到主工作表中，以保持增长的数据(Macro to copy and paste column by column from one sheet into master sheet by header to maintain growing data)

宏从一个工作表中逐列复制和粘贴到主工作表中，以保持增长的数据(Macro to copy and paste column by column from one sheet into master sheet by header to maintain growing data)

 我是Excel VBA的新手，一直在努力寻找（以及提出我自己的）解决方案，以应对我所面临的困境。 通常，我从同事那里收到原始数据文件，这些原始数据文件可能有不同数量的列，但标题名称一致。 我在我的工作簿中有一个主电子表格，我希望通过附加新数据来保持最新（因此请将新电子表格的数据附加到下一个空行）。 我想创建一个宏，可以获取导入的电子表格（例如，电子表格A）并查看列的标题值，复制列范围（从第2行开始到列填充结束），转到电子表格主页，查找标题值，并将列范围粘贴到列中的下一个空单元格中。 此过程适用于电子表格A中的所有列。  
 任何帮助/指导/建议将非常感谢。  
 例）我有“主”表和“进口”表。 我想获取“导入”表格，从第1列开始查看第1行中的标题。如果该标题出现在“主”表格中，请从“导入的表格”中复制该列（减去标题）并粘贴到“掌握“在该列中下一个空单元格开始的相应列标题下。 我最终想要做的是保留“主”表与历史数据，但“导入”表包含移动的列，所以我无法复制和粘贴范围从主下一个空单元格开始。 

I am fairly new to Excel VBA and have been trying to look for (as well as come up with my own) solutions to a dilemma I am facing. Routinely, I receive raw data files from a colleague and these raw data files may have varying number of columns but consistent header names. I have in my workbook, a master spreadsheet that I want to keep up to date by appending the new data (so keep appending data of new spreadsheet to next empty row). I would like to create a macro that can take the imported spreadsheet (say, spreadsheet A) and look at the header value of a column, copy the column range (starting from row 2 to end of populated within column), go to spreadsheet Master, look for header value, and paste the column range in the next empty cell down in the column. And this procedure would be for all columns present in spreadsheet A.  
Any help/guidance/advice would be very much appreciated. 
Ex) I have "master" sheet and "imported" sheet. I want to take the "imported" sheet, look at headers in row 1, starting from column 1. If that header is present in "master" sheet, copy the column (minus the header) from "imported sheet" and paste into "master" under the appropriate column header starting from the next empty cell in that column. What I ultimately want to do is keep the "master" sheet with historical data but the "imported" sheet contains columns which moves around so I just couldn't copy and paste the range starting from next empty cell in master.

原文：https://stackoverflow.com/questions/9802298

更新时间：2021-09-09 16:09

最满意答案

 多对多的关系不是你想要的，因为任何设备（我假设）只能有一个制造商。  
 您确实需要一个存储模型信息的中间模型，而您的EquipmentModel已有一个模型信息。 我建议修改如下：  
class EquipmentModel(models.Model):
    # This stores information about a particular model of device
    manufacturer = models.ForeignKey('Manufacturer', on_delete=models.CASCADE)
    model_number = models.CharField(max_length=50)
 
 然后，不要在Device为制造商提供外键，而是将其替换为设备型号的外键：  
class Device(models.Model):
   # ...
   model = models.ForeignKey('EquipmentModel', on_delete=models.CASCADE)

A many-to-many relationship is not what you want here, because any piece of equipment (I assume) can only have one manufacturer.  
You do need an intermediate model which stores the model information, and you already have one in your EquipmentModel. I would suggest modifying it as follows: 
class EquipmentModel(models.Model):
    # This stores information about a particular model of device
    manufacturer = models.ForeignKey('Manufacturer', on_delete=models.CASCADE)
    model_number = models.CharField(max_length=50)
 
And then instead of having a foreign key to the manufacturer in Device, replace it with a foreign key to the equipment model: 
class Device(models.Model):
   # ...
   model = models.ForeignKey('EquipmentModel', on_delete=models.CASCADE)

宏从一个工作表中逐列复制和粘贴到主工作表中，以保持增长的数据(Macro to copy and paste column by column from one sheet into master sheet by header to maintain growing data)

最满意答案

相关问答

TCP/IP模型是一个________。[2023-10-02]

游戏库存 - 设计模式(Game Inventory - Design Pattern)[2022-05-11]

库存数据库设计(Inventory database design [closed])[2023-05-08]

Django设计模型：项目/库存/用户(Django Designing Model : Item/Inventory/User)[2022-06-10]

更好的Django模型设计(better django model design)[2022-02-08]

设计库存类(Design an inventory class)[2022-05-01]

创建库存模型的最佳方法是什么？(What is the best way to create inventory models?)[2021-09-13]

Django模型设计用于基本库存应用程序(Django Model design for a basic inventory application)[2023-10-03]

使用Access进行基本库存设置(Basic Inventory Setup with Access)[2022-05-23]

laravel中库存系统的数据库设计(Database design for an inventory system in laravel)[2022-07-31]

相关文章

最新问答