I compile a report in Excel that contains 10 different sections of data. Each section is a table of values and contains data for its insertion into the corresponding sheets, which I will hide from the user's view. So I have 11 sheets, 10 for data and one for the final report.
Each data sheet will have the same number of columns each time, but the number of rows is a variable. I need a way to conditionally create and copy lines in my report under each section that matches the lines in the corresponding specification. I take a graph with the data that I insert, so I know how many lines to start.
Here is an example:
Sheet 1: Report
NAME DATE ADDRESS
Sheet 2:
Count: 3
NAME DATE ADDRESS
John 1/1/10 123 street
Mark 1/2/10 124 street
Dave 1/3/10 125 street
Therefore, I need to get this data from Sheet 2 to Sheet 1.