I am not familiar with the Macro. All I know is only a little of recording the macro then modify some value to use.
Now I am facing a problem and just thinking if anyone can help with this. Thanks in advance anyway.
I have some excel workbooks that basically have the same worksheet layout and values in the same columns of one worksheet but with different number of rows. These workbooks are saved to one folder only. I have a list of these excel files in one worksheet. All I want is that to copy these rows of data in one excel file worksheet for further analysis, or may linked this worksheet to access for analysis. This action is required to do every month so that I hope to have a macro to save effort.
Can anyone help?
Now I am facing a problem and just thinking if anyone can help with this. Thanks in advance anyway.
I have some excel workbooks that basically have the same worksheet layout and values in the same columns of one worksheet but with different number of rows. These workbooks are saved to one folder only. I have a list of these excel files in one worksheet. All I want is that to copy these rows of data in one excel file worksheet for further analysis, or may linked this worksheet to access for analysis. This action is required to do every month so that I hope to have a macro to save effort.
Can anyone help?