I have problem like this: I have installed add-in to excel and it provides me with updated data from my company's intranet system. the data is work order number description and status,they are in 3 columns of spreadsheet and I write notes in 4th, 5th,6th columns, so when i refresh data they change their place according to their work order numbers and the change occurs only in 3 colums, they move to another row.
A............. B..............C................D...............E....................F
1....12 ............bla............bla..............lala............lolo.................lulu
2....14.............bla............bla..............lili..............lele.................lala
when I refresh
25..12............bla............bla
26
27
28..14...........bla.............bla
it's ok it must be like this but the problem is that notes(D,E,F) stay at the same place. there is no relationship between work order numbers and notes. I dont know what to do Please advise
Bookmarks