Extract data from a lsit, work on it in a different worksheet and then update the list

[zentex]

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.

 

[venkat1926]

It depends upon what is meant by extract. if the extract is a subset of data you can do filtering(autofilter will be easier)

now try (Ihave not done)
do the modifiction to the filtered data and
again unfilter data.

try some expriments.