Need to Push a List of Names to Master Spreadsheet

**BYizz** · 03-05-2013, 06:34 PM

My group uses an Excel template for a different "event" we have each week. One tab of this template is a list of team members that participated in the event. I'd like to design the future template to feed a separate master spreadsheet that contains a list of every person who has participated in an event. Ideally, someone would simply use the template tab to fill the first column with last names, the second column with first names, then save and close the document and never look at it again. Is there a way to link another Excel spreadsheet so that the data is pushed rather than pulled? Thanks.

**arlu1201** · 03-06-2013, 02:01 AM

Yes it can be done. Do you have a sample of your template and the master file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**BYizz** · 03-13-2013, 01:16 PM

I'm not sure if what you suggested would work for me.

Every week, there is a new event that will be populated with different names, an example of the name template is posted below. I have not created the master spreadsheet yet, but ideally it would just have the list of names from every event, and would automatically populate with the new names as soon as a new file is saved. For example, I will open a new template, populate cells B5 thru B7, then save and close that file. Then the next week, I will open a file based on the same template, populate cells B5 thru B7 with new names, then save and close. I want this master spreadsheet to account for the new names that are added each week. I feel like it would be difficult to use the master spreadsheet to pull from the others, since the name of the template files are not always consistent and it would also have to account for files that have not been created yet.

Template.PNG

**arlu1201** · 03-14-2013, 08:25 AM

I'm not sure if what you suggested would work for me.

I have not suggested anything yet

Each time your file would be different so where would you keep the macro? Is better you do a PULL into the master file. The macro can prompt you to open the file and then execute the further steps.

**BYizz** · 03-14-2013, 03:55 PM

Originally Posted by arlu1201

I have not suggested anything yet

Each time your file would be different so where would you keep the macro? Is better you do a PULL into the master file. The macro can prompt you to open the file and then execute the further steps.

I actually figured it out! Thanks for your time. I didn't need to "pull" at all, I just created a macro to copy the values.