Copying multiple rows of data from multiple spreadsheets to one spreadsheet

sthorner

New Member
Joined
Jun 8, 2011
Messages
1
Hi Everyone,

I'm having a bit of trouble with a project that I've recently been tasked with at work.

Basically, I have 4 worksheets that each contain a list of situations/instances with about 10-15 fields (columns) that are continuously updated, where each row would be an independent situation/instance. These worksheets are titled "FCAC," "Members," "CRM," and "Other", respectively. I will henceforth refer to these spreadsheets as "info. lists."

I then have one master spreadsheet called "Overview", which ideally would become a "master list" which displays all of the situations/instances from the 4 "info. lists" in one spreadsheet.

Ideally I'm looking for a way to simply copy the values from the rows in each "info. list" (excluding the column titles - as they are identical throughout all of my worksheets) to the main "Overview" list.

Where it gets a little complicated is that I need to design the code so that my colleagues can, for instance, add/remove a situation/instance to any one of the 4 "info. lists" and then be able to see this addition automatically and immediately reflected on the "Overview" spreadsheet. Alternatively, I wouldn't be opposed to requiring the user to click an "Update Overview Sheet" button that would be assigned to the Macro that would accomplish the updating/transposing of the data, if it would be necessary.

I should mention that I am using Excel 2003. I have some prior programming knowledge with regards to PHP, ActionScript, HTML, etc., although to be honest it was more of a personal hobby and I haven't been programming for a while. I have next-to-no knowledge of VBA and Macros, but I am a quick learner and given my background of programming I do not think that learning another language would be exceptionally difficult.

If you need me to clarify anything that I have said please do not hesitate to ask.

Thank-you in advance for your help,

Scott
 
Last edited:

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Welcome to the Board.

See if this link will help you out:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

There is a downlodable working file at the end.

Since you say you have some programming knowledge you might be able to adapt this.

Give it a try and post back if you run into problems. Please explain any problems you run into.

Good Luck ;)
 
Upvote 0

Forum statistics

Threads
1,224,552
Messages
6,179,487
Members
452,917
Latest member
MrsMSalt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top