Combining data

[alshaer99]

Dear All,

Greetings,

I am working with Civil Project management team. we have three main divisions in our team (Time controller - Cost Controller - General and support). all these three divisions are entering a different information about the same project list but each one have their own format in excel so we face very difficult time when we try to combine the data. My questions are:

1- is there any automated way to combine the data in a master sheet using excel
2- usually we received a specific templates from top management to fill them up, Is there any way to do this automatically from our master sheet
3- which is better software to use in our case, Excel or Access

Sorry for my long query and awaiting your support

thanks


Khalid

[June7]

For 1 and 2 I have to say probably not, at least not without a lot of code or by linking to the sheets from Access. In Access the linked sheets can be worked with like tables, although data could not be edited.

For 3 I say Access.

[alshaer99]

For 1 and 2 I have to say probably not, at least not without a lot of code or by linking to the sheets from Access. In Access the linked sheets can be worked with like tables, although data could not be edited.

For 3 I say Access.

Thank you for your reply