I have two excel sheets. One is report which is generated every day with a different number of lines. These lines should be added to the other excel sheet at the beginning below the two header rows.
Works so far fine with “Insert Rows”, but not with “Copy Paste Range”.
I have this range for example with the daily report and five rows of data.
A fix range like this works fine.
But the range changes with the number of lines in the daily report, e.g.
1 line the range is A3:Y3
2 lines is A3:Y4
5 lines is A3:Y7
How can I use a dynamic range? Is there maybe an VB expression which I could use.
Yes I know about “Append Range” which would be a lot easier and works great, but the User wants to have the new lines at the beginning of the sheet. Filter is also not an option because of “merged cells”.