如何在VBA的帮助下从包含许多工作表的Excel工作表中查找数据 [英] how to find a data from the excel sheet consisting of many worksheet with the help of vba

问题描述

有人可以帮忙编写一些代码来检索Excel工作表中特定字段中的数据吗?
该工作表包含许多工作表.

编码应使用excel VBA

Can someone help to write some code for retreiving data from a particular field in an excel sheet.
The sheet consist of many worksheets.

The coding should be in excel VBA

推荐答案

您在我的计算机中拥有一个Excel Guru，它将很容易为您提供所需的内容.

但是，我需要一些其他信息.

请准确定义您的需求.

您是要跟踪特定工作表中的单元格还是范围内容?

您需要将它们复制到新的工作表吗?

什么?

有关您的要求的更多详细信息将使我更好地回答您.

(我可能已经掌握了基本的代码，因此只要知道我想要的内容，现在就可以将其复制并粘贴到此处).

You have in me an Excel Guru, and it will be very easy to give you what you want.

However I need some extra information.

Please define exactly what it is that you need.

Are you after the cell or range contents in a particular sheet?

Do you need them copied to a new sheet?

What?

More detail about your requirements will let me answer you better.

(I probably have the basic code you require kicking about so it is a matter of moments to copy and paste it here, so long as I know what you want).

这篇关于如何在VBA的帮助下从包含许多工作表的Excel工作表中查找数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！