Hi everyone,

New to the forum, it is also the first time that I use excel for professional reasons (excel 2003). Here is my problem, help would be highly appreciated.

I am currently carrying on a mapping of all development projects in an country. For that purpose, I build a simple excel database with these projects and information about them (name, sectors, location, amounts, dates, etc..).

My problem comes from the fact that projects have to be filled up by financing organizations themselves. I can only check the data after them. Thus, I would like my database to have a dedicated sheet for every organization, in order to avoid that they change/delete/create data of other organizations. That why I created several identical sheets for every organization (say X/Y/Z/...)

But of course, the final need is to have a master compilation spreadsheet with all projects together (called "ALL Projects"). And I would like this spreadsheet to be filled up and updated automatically when changes are done and projects added by organizations in their sheet.

So I thought about displaying a succession of several dynamic named ranges (called "X_Projects", Y_Projects", etc...) into the master spreadsheet.

But this raises two questions:

- To create these dynamic ranges, I used INSERT-NAME-DEFINE and used the code OFFSET with COUNTA (detailed in the example database in the X sheet). Is this code really working for big ranges including numbers, text, but also dates and list selection?

- If yes, then how to display these defined dynamic ranges following each other in the master spreadsheet, for it to be automatically updated. Again, data to be displayed are the same for every project.

- If no, would you have any other suggestion for me? I looked for this for hours, and am completely stuck. Links to tutorials or other posts are welcomed too.

Please find enclosed a light example of my database, to better understand what I mean. example.xls

Thank you very much guys!
Best regards