how to maintain formatting (such as highlighting) when importing in ms query

I haven't found an elegant solution to this problem and have posted on another forum, as well. My current solution is to filter the Master Log so I only see Region 2, copy everything, then paste over Region 2, and repeat with 3, 4 and 5.

I have a master log (attached) that I import using Microsoft Query to 4 other spreadsheets (called Regional Logs), depending on the contents of the column "Region." I have all this figured out, but I can't figure out how to have the highlighting persist through the export and refresh. I don't think the attached file has any highlighting, but how I use this is I edit the Master Log throughout the week and highlight changes as I go. Coworkers use the 4 Regional Logs throughout the week to monitor different cases, particularly the new ones, so they need to see all changes for the week highlighted in yellow, which means the Regional Logs need to be linked to the Master Log and the highlighting must be visible any time a coworker opens the Regional Log. In addition, they are emailed across the state to county directors and they need to see the yellow-highlighted data, as well.

Currently, when exporting data using MS Query, no formatting persists. How can I ensure the highlighting persists? Or, is there another way to easily export the data, depending on the contents of the column "Region", which would allow the highlighting to persist? I hope that I have made myself clear, thank you.

Hi auslegung,

you title says you are facing issue when importing but in post body you mentioned that you are facing issue in exporting.

If you wish to save formatting in the tab, in which data is getting imported, suggest you to first import in some other blank sheet and then copy paste special values in already formatted (Conditional formatted) sheet. thanks.



Regards,
DILIPandey
<click on below * if this helps>

Are not importing and exporting the same thing, only viewed from different perspectives? They achieve the same results.

Its different for me It something like "source formatting" vs "destination formatting". In one of my project related with date extraction, where I needed the data output in some specific format, hence I took two approaches at that time 1) formatting the source itself so that data output comes in desired format 2)formatting the destination - where using macro, I pasted output data values in some pre-formatted sheet and for me both the approaches work

so just thought to share my experience to help you - nothing else.



Regards,
DILIPandey
<click on below * if this helps>