Hi all,
Ever period, our POS report creates a sales file that we can export, but the problem is that it creates one file per store, and I have to manually copy and paste the data from one file to the other to combine them.
My question: Is there a macro I could run that would do this for me? I could keep the file names the same each period if needed. Essentially, is it possible to create a macro to take all of the data in one file and add it to the bottom of another, and repeat with several other files.
I have to admit I am not the best with macros (still learning). If anyone can help here or point in the right direction, it would be greatly appreciated.
Thank You,
Dolphn22
Ever period, our POS report creates a sales file that we can export, but the problem is that it creates one file per store, and I have to manually copy and paste the data from one file to the other to combine them.
My question: Is there a macro I could run that would do this for me? I could keep the file names the same each period if needed. Essentially, is it possible to create a macro to take all of the data in one file and add it to the bottom of another, and repeat with several other files.
I have to admit I am not the best with macros (still learning). If anyone can help here or point in the right direction, it would be greatly appreciated.
Thank You,
Dolphn22