Hello! I've just started working with vba and have some difficulties with a code to copy and paste.
I have 2 workbooks, the first one is called months and the second summary.
In months there is a worksheet for each month (JAN, FEB, ...) and every month some rows of a table (B3: E15) are filled (but not the same number of rows each month).In summary I want to make a summary of the first one, so I need a code that goes to months to copy the lines that are filled in JAN, if JAN doesn't have more full lines goes to FEB and copies the filled lines, if FEB doesn't have more full lines goes to MAR and so on.
I hope you can help me!
Thanks!
I have 2 workbooks, the first one is called months and the second summary.
In months there is a worksheet for each month (JAN, FEB, ...) and every month some rows of a table (B3: E15) are filled (but not the same number of rows each month).In summary I want to make a summary of the first one, so I need a code that goes to months to copy the lines that are filled in JAN, if JAN doesn't have more full lines goes to FEB and copies the filled lines, if FEB doesn't have more full lines goes to MAR and so on.
I hope you can help me!
Thanks!