Hi, I need help regarding a query I run from MS SQL and pull the data in Microsoft Excel 2010. I have inserted another worksheet so one of our user can add more columns to analyse cost or reason for returns/failures. When return department add another line to an existing data in MS SQL and the other user refresh the excel spreadsheet then manually added columns go out-of-sync. Is there anyway when a user refresh the RAWDATA or any changes on SQL table then it should sync my formatted worksheet. It is a bit complicated to explain as well. Thanks in advance or let me know if I have not made any sense. |
<tbody>
</tbody>