RN copy data from workbook to workbook

  • Thread starter Thread starter Robert N
  • Start date Start date
R

Robert N

I Need help with following problem.
I need to copy/link data from one workbook to another eg:
MasterData has 375 rows of data each row has 4 col
Job.....Student Name.....Supervisor.....School
This data is sorted by School then by Student Name
I want to grab all rows where column called School = "DTS" then copy o
link this data and display it in a new workbook called DTSdata. Then
would want to do the same for all other schools again displaying onl
the data from the 375 rows.
It would be great to have the data automatically update in workboo
DTSdata if the data in MasterData changed. In my thinking it should b
something like this:

From workbook DTSdata lookup a range of rows and columns in MasterDat
IF column School = "DTS" grab the row or rows and paste or link t
workbook DTSdata.

Can I do this in excel and if so how
 
I wouldn't do it based on data entry, but you could invoke a macro on demand.

You could steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top