Hi,
I want to be able to
1. extract data (rows) from a list to a different worksheet
2. work on the extracted data (add, delete, edit rows/data) in the different worksheet
3. then update the original list
CURRENT/PAST METHOD I HAVE TAKEN
In the past I have done the following:
1. Create an excel "List" for that list
2. in MS Access, dynamically link to the list and have a query back in Excel for the bunch of data that I need to view and automatically plot
3. I then make the changes directly in the List after viewing them in the plot
Disadvantages of the current method
1. I can't move my excel file elsewhere or rename it, otherwise Access will not find it. I have 2 files for thsi task (excel and Access, which is not very elegant).
2. I am editing directly in the List instead of elsewhere which is not very elegant, I have to search through the rows
Here is what I think of doing now
I would like to start from scratch and just work in Excel. I imagine myself building a macro that extract the data I need and after doing the changes, another macro will help to delete the old data in the List and put in the new set of data.
I am wondering if any of you have any better ideas? or suggestions to make my life easier? I have done some simple VBA coding in the past but nothing really advanced.
Thanks in advance.
I want to be able to
1. extract data (rows) from a list to a different worksheet
2. work on the extracted data (add, delete, edit rows/data) in the different worksheet
3. then update the original list
CURRENT/PAST METHOD I HAVE TAKEN
In the past I have done the following:
1. Create an excel "List" for that list
2. in MS Access, dynamically link to the list and have a query back in Excel for the bunch of data that I need to view and automatically plot
3. I then make the changes directly in the List after viewing them in the plot
Disadvantages of the current method
1. I can't move my excel file elsewhere or rename it, otherwise Access will not find it. I have 2 files for thsi task (excel and Access, which is not very elegant).
2. I am editing directly in the List instead of elsewhere which is not very elegant, I have to search through the rows
Here is what I think of doing now
I would like to start from scratch and just work in Excel. I imagine myself building a macro that extract the data I need and after doing the changes, another macro will help to delete the old data in the List and put in the new set of data.
I am wondering if any of you have any better ideas? or suggestions to make my life easier? I have done some simple VBA coding in the past but nothing really advanced.
Thanks in advance.
Last edited: