linking sheets and workbooks

C

carolina.vl

Hi - I know this is pretty basic but I need to have data from one sheet in one workbook, linked or somehow automatically populated (copied) into a Master compilation workbook, as I call it. It is basically text information onstudents (address, date of enrollment etc) but the schools where they areenrolling are in different parts of the country, and I am hoping that for each school, when data on a new student is entered into their individual school excel workbook, that the information can be copied into the Master workbook, so as to have all the information on new students in one workbook and not have to compile manually.

Is this possible?
thanks!
 

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

Linking Workbooks - Reopen Error 0
VBA code to import worksheets from other workbooks 9
Use a master workbook to carry over changes to multiple workbooks 1
Unwanted workbooks on startup 2
OneNote and MS Forms 0
Macro to Compile Data from Different Sheets 2
Need Help! Need to Change Linked Source on Several Workbooks. 0
Mail Merge - List multiple items then page break on unique data 1

Top