I want to create a sheet containing all of the data from multiple sheets
(or workbooks).

The good news is that each of the source sheets follow the same
template with the same column headings.

To give you an idea of the objective I need an overall consolidated
sheet containing all of the information in the original source sheets.
So for example I have a sheet containing systems for our MI team and one
for systems for our claims team. The destination sheet should contain
info from both teams in the same sheet.

Ideally this would be linked so that it is updated when the destination
sheet is opened, however if this is not possible then I would imagine it
would be no trouble to assign a macro to the task of pulling the data
together.

Any takers???

Cheers

Mark.


--
markbhai
------------------------------------------------------------------------
markbhai's Profile: http://www.excelforum.com/member.php...o&userid=34461
View this thread: http://www.excelforum.com/showthread...hreadid=542152

markbhai wrote:
[do my homework snipped]
> Any takers???

Sure. What's your hourly rate?
Socks

Thanks Muppet.

No I am afraid I stopped doing homework 23 years ago when I left
school.

Can anyone else help?

Cheers

Mark


--
markbhai
------------------------------------------------------------------------
markbhai's Profile: http://www.excelforum.com/member.php...o&userid=34461
View this thread: http://www.excelforum.com/showthread...hreadid=542152

markbhai wrote:
> Thanks Muppet.
>
> No I am afraid I stopped doing homework 23 years ago when I left
> school.
>
> Can anyone else help?

You don't take hints well.

The name is not Muppet. It is Puppet Sock.

Usenet manners means you quote enough of what you are replying
to for people to get the context. Not everybody reads this on google.
Not everybody can see the previous messages. If you are using
google, you hit Options first, then Reply on the link that shows up,
and it autoquotes for you.

You asked for somebody to make you an Excel application. My rough
and ready estimate was it would be some days or weeks of work.
You never mentioned payment. If you want anybody to believe you
are not trying to weasel your homework, then you should realize that
typical developer rates are $50/hr or more. "Anybody want a challenge"
is not going to entice anybody into doing some mundane little
report generator for free.
Socks

Suggest you use a blank access database and import all the sheets into a new
table and when done, export back to Excel

Saruman
----------------------------------------------------------------------------
---------
All Outgoing Mail Checked With Norton Antivirus 2003
----------------------------------------------------------------------------
---------

"markbhai" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I want to create a sheet containing all of the data from multiple sheets
> (or workbooks).
>
> The good news is that each of the source sheets follow the same
> template with the same column headings.