excel选定区域加密
You have an Excel order form with a long list of products to select. After a customer enters quantities for the products they want to order, you want to print an invoice for the selected items.
您有一个Excel订单表,其中包含一长串可供选择的产品。 客户输入他们要订购的产品的数量后,您要为所选项目打印发票。
选择产品 (Select the Products)
Here's the OrderForm sheet, where quantities have been entered for four of the products, in column E.
这是OrderForm工作表,其中在E列中输入了四个产品的数量。
Formulas in column B check the quantity column (E). If the quantity is filled in, then the next available number is calculated.
B列中的公式检查数量列(E)。 如果已填写数量,则将计算下一个可用数字。
=IF(E6>0,MAX($B$5:B5)+1,"")
= IF(E6> 0,MAX($ B $ 5:B5)+1,“”)
打印订单 (Print the Order)
On the Invoice sheet, formulas pull the data from the Order form. For example, this formula shows the name of the first product that was ordered:
在“发票”表上,公式从“订单”表单中提取数据。 例如,此公式显示订购的第一个产品的名称:
=IF(MAX(OrderForm!$B:$B)<$B12,"", INDEX(OrderForm!$C$6:$C$12, MATCH($B12,OrderForm!$B$6:$B$12,0)))
= IF(MAX(OrderForm!$ B:$ B)<$ B12,“”,INDEX(OrderForm!$ C $ 6:$ C $ 12,MATCH($ B12,OrderForm!$ B $ 6:$ B $ 12,0)) )
Here's the Order Form sheet, ready to be printed. The numbered rows from the Products sheet have been added to the Order form. Products without a quantity, such as Sweater, don't appear.
这是准备打印的订购单。 产品表中已编号的行已添加到“订单”表单中。 没有数量的产品(如毛衣)不会出现。
样本文件 (The Sample File)
To download the sample file, please visit the Excel Sample Files page, on my Contextures website.
要下载示例文件,请访问我的Contextures网站上的Excel Sample Files页面。
In the Functions section, look for FN0027 - Print Marked Invoice Items. ___________________________
在“功能”部分中,查找FN0027-打印标记的发票项目 。 ___________________________
翻译自: https://contexturesblog.com/archives/2009/11/23/print-selected-items-on-excel-invoice/
excel选定区域加密