How to automatically combine data from multiple worksheets into a master worksheet

**BeardedLuminary** · 02-27-2013, 09:29 AM

I am attempting to create a template worksheet that several different people will be independently working from, creating several different worksheets to be saved on a Windows network share drive. The template spreadsheet will contain approximately 8 columns of unique data utilizing no formulas. What I need is for the data from each of those worksheets to automatically populate a master worksheet on a daily basis. I am completely new to this, so I'm not sure if this can be accomplished from an excel formula, macro, or visual basic.

Thank you for any assistance this forum may provide.

**arlu1201** · 02-27-2013, 10:08 AM

Would fresh data be copied to the template sheet each day or would the people populate the data in the next available row?

**BeardedLuminary** · 02-27-2013, 10:13 AM

Each person would continue to add to their individual worksheet daily, and I would need the master worksheet to recognize what data it had already pulled, if possible.

**arlu1201** · 02-27-2013, 10:16 AM

Ok, so to exclude duplicates, it will be good if the master sheet is cleared of all data (except headers) before fresh data is input. Will that affect your further processes in any way?

**BeardedLuminary** · 02-27-2013, 10:18 AM

If necessary, that should be fine.

**arlu1201** · 02-27-2013, 10:28 AM

Would you want the user to open up the network file or should the path be hard coded in the macro?

**ExcelWizards** · 02-27-2013, 10:29 AM

Excel can already do this without additional VBA.

**BeardedLuminary** · 02-27-2013, 10:30 AM

The file will not move once set, so I see no reason it can't be hard coded.

**arlu1201** · 02-27-2013, 03:45 PM

One last question -

Since multiple people will be populating their individual files, should the master file contain 1 tab per person and update the individual data sets? Or should everyone's data be consolidated into 1 tab?

Incase everyone's data is consolidated into 1 tab, do you need the name of the tab to reflect, from where the data was copied?

**BeardedLuminary** · 02-27-2013, 09:27 PM

The master file would contain 1 consolidated tab. The name of the tab can be anything it needs to be.

**BeardedLuminary** · 02-28-2013, 10:57 AM

Bump for a response

How to automatically combine data from multiple worksheets into a master worksheet

LinkBack

Thread Tools

Rate This Thread

Display

How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Re: How to automatically combine data from multiple worksheets into a master worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions