Quote:
Originally Posted by Shetal Shah
Were you ever able to figure out this issue? I'm having the same issue. I work for a school and have 200 kids with data. I used a query to fileter in demographic data and the teachers have enter in their data manually. But if I have to add a new student it messes up all the data on the right side that the teacher entered. Help.. I'm completely at a loss.
Thanks,
Shetal
|
Hi Shetal,
It is indeed frustrating. I tried several options but couldn't get through. One suggestion that I have is to use a bit of VBA (I can help you with the code if you are happy with the idea). The idea is to run a VBA macro that creates a copy of your existing sheet and then refreshes the data from your query. The new data then refers to the old sheet and applies a lookup function (using a unique ID) to get all the details of existing rows of data. This way you don't have to worry about the position of your data. At the end of it the macro deletes the dummy sheet.
It may sound like a big task but shouldn't take more than 10-15 lines of VBA code.
By the way, if you come across a better idea please let me know.
Thanks
Prashant Kumar Pathak
Similar Threads
Hybrid Mode
