how do I combine multiple worksheets into one? not summarize
i have multiple worksheets from the 'old' XL that max at 65k rows. i want to
combine all of the data into one worksheet using the new XL that allows 1mil
rows of data. from there I will manipulate, make changes, then create pivots
and charts.
|