share workbook/sheet
 

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

share workbook/sheet
 

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson

share workbook/sheet
 

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson

share workbook/sheet
 

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

Steen wrote:

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson


--

Dave Peterson

share workbook/sheet
 

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

Steen wrote:

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson


--

Dave Peterson

share workbook/sheet
 

I've never used it in real life.

And there are lots of posts that describe problems with it.

If you decide to use it, make backups often.

Steen wrote:

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

Steen wrote:

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

share workbook/sheet
 

Hi Dave

Thanks for you answer and advice :-)

I think I will look for another solution - might even end up buying a
solution (Scrum tool)...

/Steen

"Dave Peterson" skrev:

I've never used it in real life.

And there are lots of posts that describe problems with it.

If you decide to use it, make backups often.

Steen wrote:

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

Steen wrote:

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson