阅读背景:

如何基于变量条件从多个工作簿复制数据行,然后粘贴到主工作簿

来源:互联网 

I am very new to VBA and after hours of searching I have found a code to copy all rows of data from multiple workbooks into a master workbook. The data in the user workbooks is updated daily. However, I do not wish to delete the data from the user workbooks so when I run the macro for a second time to capture the new data, it copies all the rows again and therefore duplicates the data in the master workbook. Column T of the workbooks contains the week number of the entry of the row of data. I would like to use an input box to specify the week number to search for, then copy the entire row. This way I can run the macro once a week but only update the master with the previous weeks data instead of the entire worksheet. Here is the macro I currently have. Please can anyone help to modify it?I am very new to VBA and after hours of searchi




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: