Hello,
I need help building a macro for a report that I must make on a weekly basis that does the following: on a worksheet called "Macro Instructions" in cell K5, I want to be able to write the name of the xls file, and then have it extract that data to a worksheet (in the same worksheet as the macro instructions worksheet) called "Report" and input the data from Column A starting at A2 to AC. Assume that the data that is being extracted always has the same number of columns. There sometimes is more rows than others. If this is possible, I'd greatly appreciate it! Thank you
I need help building a macro for a report that I must make on a weekly basis that does the following: on a worksheet called "Macro Instructions" in cell K5, I want to be able to write the name of the xls file, and then have it extract that data to a worksheet (in the same worksheet as the macro instructions worksheet) called "Report" and input the data from Column A starting at A2 to AC. Assume that the data that is being extracted always has the same number of columns. There sometimes is more rows than others. If this is possible, I'd greatly appreciate it! Thank you