A Challenge!! - Pulling Data into one sheet,

M

markbhai

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.
 
M

markbhai

Thanks Muppet.

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

Can anyone else help?

Cheers

Mark
 
P

Puppet_Sock

markbhai said:
Thanks Muppet.

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

Can anyone else help?
Click to expand...

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
 
S

Saruman

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

Saruman
 

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

Imbedded Data Input sheet 3
Copy row data from one sheet to one or more sheets depending on numberof tick boxes selected (in the 3
Lookup more then one sheet as reference 1
Pulling Data from Master Table Dynamically Into Secondary Workbook Sheets 1
Cannot insert the sheets in to the destination workbook 1
Pulling data from one sheet to another 1
Let User Select Sheet to Pull Data From 7
Unable to read file 2

Top