关于excel宏 [英] Regarding excel macro's

问题描述

大家好，



我只是尝试使用Excel宏，我需要特定的列数据来自动过滤和过滤数据，以便从该表中剪切并移动到同一工作簿中的另一张表，

我将用一个例子来解释，



在具有D列数据的Excel中，D列数据为使用GA或不同的基于文本的数据等文本进行排序或过滤，这些基于文本的数据应该移动到sheet1到sheet2。如果要将D列数据首先过滤并根据文本将此数据复制或剪切并移至sheet2。我也需要列数据和行数据。



请有任何人对上述问题有所了解，请与我分享



谢谢，



我尝试了什么：

Hi Everyone,

I am just trying with Excel Macros, I need particular column data as to filtered automatically and filtered data as to cut from that sheet and move to another sheet in the same workbook,
I will explain with an example,

In Excel having D Column data, D column data as to sorted or filtered with Text like GA or different text-based data and this text-based data should be moved to sheet1 to sheet2. If column D data as to filtered first and based on text this data as to be copied or cut and move to sheet2. I need Column data with row data also.

Please anyone having an idea for above-mentioned problem, share me

Thank you,

What I have tried:

I am just tired with Excel Macros, I need particular column data as to filtered automatically and filtered data as to cut from that sheet and move to another sheet in the same workbook,

推荐答案

您可以使用Excel中的宏记录功能找出基本知识。开始录制，执行所需的所有步骤，停止录制。然后，您可以编辑捕获的宏并根据需要进行调整。您还可以找到许多专门研究该主题的网站。

You can figure out the basics by using the Macro Record feature in Excel. Start recording, perform all the steps you want, stop recording. You can then edit the captured macro and adjust as necessary. You can also find lots of websites that specialise in the subject.

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