如何创建将基于SKU值自动填充/计算单元格的模板? [英] How can I create a template that will auto populate/calculate cells based on a SKU value?

问题描述

每天，我都会处理产品数据，包括产品创建以及为Web，eBay和Amazon创建清单的工作.为了加快过程并更好地维护数据的独创性，我试图创建一个使过程自动化的工作簿.目的是能够输入/复制单个或唯一SKU编号列表.我创建了公式，然后解释SKU模式并提取重要的产品信息.我的问题是，然后我需要拖动填充手柄以开始计算该信息. Excel中有什么方法可以自动填充每个SKU行中的单元格吗? SKU的列表始终从1个SKU更改为数千个.我可以将公式填充到每一列的末尾，但是，这极大地减慢了我的处理速度.我需要一种快速，动态的方式来基于SKU或SKU自动填充整个电子表格.

Every day I work with product data, both product creation and listing creation for the web, eBay, and Amazon. To speed up the process and better maintain data originality I am trying to create a workbook that automates the process. The goal is to be able to enter/copy an individual or list of unique SKU numbers. I have created formulas that then interpret the SKU pattern and pull out vital product information. My problem is that I then need to drag the fill handle to begin calculating that information. Is there any way in Excel that I can auto-populate cells in each SKU row? The list of SKU's is always changing from 1 SKU to thousands. I could fill the formula down to the end of each column, however, this drastically slows down my processing. I need a fast and dynamic way to autofill my entire spreadsheet based on a SKU or SKU's.

推荐答案

使用 Ctrl + T 键盘快捷键将模板转换为Excel表.这些已计算的列可自动填充公式，表本身会自动扩展以容纳新数据.有关更多信息，请参阅我的博客文章，网址为

Turn your template into an Excel Table using the Ctrl + T keyboard shortcut. These have calculated columns that autofill formulas, and the tables themselves auto expand to accommodate new data. For more info, see my blogpost at https://chandoo.org/wp/2014/03/28/tables-pivottables-and-macros-music-to-your-ears

这篇关于如何创建将基于SKU值自动填充/计算单元格的模板?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！