Tables Feeding data into a Further Table

Hi,

I was wondering if someone could help me out as my overall knowledge of excels higher functions is virtually non-existent. I need to put together a number of worksheets, each worksheet is to record project information that's happening at our production sites and all the tables are uniform in design. There also needs to be one 'master sheet' in which all the information added on the lower sheets is automatically added.

So basically I need to have four tables on separate sheets that feed information in to one table on a further sheet.

Can anyone tell me how to do this?

Take a look at the file I submitted to this thread:

http://www.excelforum.com/excel-gene...html?p=3073438

and see if you can adapt it to your requirements.

Hope this helps.

Pete

Thanks Pete,

I've taken a look and it looks like it could be changed to do what I need but I'll be honest and say I'm not confident enough with the formulas to change them to get it to do what I want. Any chance of a few pointers??

the attached macro will consolidate all rows from all tabs into master, I added the tab name in column A for clarity

Yes there are ways to do that. This is the brute approach in which everything is copied.
For the the brute approach I would suggest a button to be clicked or a CTRL-something to trigger the macro

A more sophisticated way is to "add/update" only the new records or changed records , but that is another ball game...

enclosed is the button solution (it is located in Master in the B1 column vicinity)

Thanks, thats great. I can always delete the finished projects from the master. Thanks for your help.

If you like just mark or give the column details of the finished projects and they could be excluded from the brute transfer...

Okay, now I really feel out of my depth, mark them how exactly?

Include a "FINISHED" column on the right in the project tables and mark them with anything. It will only transfer those records with the an empty FINISHED cell

For some reason it throws up a run time error

The A1 cell in the MASTER tab should be 5 (its the starting row)

I placed a 5 in the A1 cell but for some reason why I press consolidate it deletes the five after updating which means that you have to re enter A1 as 5 each time to avoid a run time error. Really sorry about this, you've done more than enough already.