EvolvedFromQuincy
New Member
- Joined
- Jan 27, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi all,
I am trying to combine the data from daily .xlsm reports into one sheet with all of that data for each calendar year. The catch is that the data is color coded via row highlights, which is the basis of its usefulness. Using "Get Data>From File>From Folder," is there a way to preserve the color highlights? Or is there any other method available? The text data alone is unfortunately useless to us without the relevant color highlights.
I realize that color highlights are perhaps not the best way to convey this necessary information, but it is what I have to work with at present.
Many thanks
I am trying to combine the data from daily .xlsm reports into one sheet with all of that data for each calendar year. The catch is that the data is color coded via row highlights, which is the basis of its usefulness. Using "Get Data>From File>From Folder," is there a way to preserve the color highlights? Or is there any other method available? The text data alone is unfortunately useless to us without the relevant color highlights.
I realize that color highlights are perhaps not the best way to convey this necessary information, but it is what I have to work with at present.
Many thanks