Excel技巧 [英] Excel trick

问题描述

我有一个工作簿，其中包含3个用于打印支票的工作表
1号工作表是日志
第二张是付款凭证(数据源是日志)
第三是支票表(数据源是付款凭单)

第一步
我按照检查顺序在日志表中填写了需要的数据(金额，受益人，日期)

第二步
我会手动更改付款凭证中每个单元格的单元格引用(金额，受益人，日期)

然后自动更新检查表

我想做的是:
在凭证表中添加按钮以上下修改参考

致谢

i have a workbook contain 3 worksheets for printing cheques
1st. sheet is log
2nd sheet is the payment voucher ( data source is log sheet )
3rd is the cheque sheet ( data source is payment voucher sheet )

1st step
i fill in the log sheet the need data ( amount, beneficiary, date ) this as per the cheque sequance

2nd step
manually i do change the cell reference in the payment voucher for each cell ( amount, beneficiary, date )

then automatically cheque sheet is updated

what I''m trying to do is:
to add a button in the voucher sheet to modify the reference up and down

thanks and regards

推荐答案

使用宏记录器模拟您使用的手动过程，然后对其进行修改以编程方式进行.完成后，在表单中添加一个按钮，并将您创建的宏分配给该按钮.很久以前，我在时间表上做了类似的事情. VBA宏是您的朋友.

Use the Macro recorder to simulate the manual process that you use and then modify it to do it programmatically. Once complete, add a button to your form and assign the macro you created to that button. I had done something similar with timesheets a long time ago. VBA macros are your friends.

这篇关于Excel技巧的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！