RN copy data from workbook to workbook

R

Robert N

Thanks for your reply.
I have never worked with Macros.
I did go to the site sugested and downloaded 1st file under filter
named "filtersAdvFilterRepFiltered.xls"
I have tried to determine how I could modify this marco to suit m
needs. This macro does exactly what I need.
My current file MasterData currently has data in Rows 65 thru 420
There are 6 columns
Code1...Job Name...Student Name...Supervisor...School...Code2
I want to create a new sheet with data for each SUPERVISOR
and then for each School.
Would anyone be willing to take the existing script as noted above an
modify it for me.
I also need to know how the button was created in the example.
Looks like a big request but I sure would appreciate some help
 
M

Max

Just to drop a note here ..
I've suggested a formulas approach in response
to your identical? post in .worksheet.functions
Something extra for you to play around with ..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RN copy data from workbook to workbook 1
linking sheets and workbooks 0
Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Multiple workbooks from customers 3
Howto populate a column with values coming from another sheet 2
submit button and auto update for workbook? 1
Macro VBA coding, Copying content from one workbook to a new one 0
Dividing worksheet into multiple workbooks 3

Top