Combining Data

ScreamsAtBirds

Hello,

I have two sheets within a folder. I would like to be able to automate the combining of the data from these sheets into a new sheet which I could think use to build a report. Is there an easy way to combine the data? The sheets have different columns so replacing the data is not needed.

Heather_Verde

You can build a report from multiple sheets, so there may not be a need to combine them.