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

zentex

New Member
Joined
Jul 2, 2008
Messages
20
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.
 
Last edited:

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,986
Messages
5,621,998
Members
415,873
Latest member
fuulhouse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top