I am trying to append a range from multiple excel worksheets into one worksheet in a different workbook. I am stuck on the Append range activity specifically the What to Append Parameter. The step before I am using a Find First/Last Data Row to get the range to append and storing those values for later use in the Append Range What to Append Parameter. The problem is I can’t figure out how to incorporate the saved (First/Last) values into the What to Append parameter.
Any help is greatly appreciated.