April 20, 2015 at 8:30 am
Hi,
I run a query from Excel to pull the data from SQL server and I have created another worksheet to add my columns for different analysis and costs.
When someone add another line in SQL against an order or a customer then manually added columns data goes out of sync.
Is there anyway when I refresh the RAWDATA or anything 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.
April 20, 2015 at 9:17 am
You can set excel to automatically refresh every X minutes.
April 20, 2015 at 9:21 am
But when a user adds another line to an existing returns order the manual columns go out of sync.
for example
Id ProductName Manual column
2 Tyre Refund
3 Tubes Faulty
4 Tools Exchange
When another product that has two orders and added on the system
Id ProductName Manual column
2 Tyre Refund
2 Tyre Tubes Faulty
3 Tubes Exchange
4 Tools
April 20, 2015 at 9:23 am
What do you mean by manual column, is that a column in excel or a column from the query you are running?
April 20, 2015 at 9:26 am
I created manual columns in excel.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply