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:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,657
Messages
5,838,632
Members
430,558
Latest member
Krampus

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