Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
So i apologize if I missed the answer to my question.

I am attempting to develop an Excel worksheet that will ultimately pull the
data into a word doc using the Copy - Paste Special method.
What i am wondering is that in one section of the word doc is a Requirements
page. This page can have anywhere from 1 to 50 separate line items on it.
Each one is numbered, (1. 2. 3., etc)
Instead of just creating 50 numbered lines and using 50 cells in the excel
worksheet then going back after updating the information on the word doc and
deleting the blank numbers not used, can i either:

a) on the excel worksheet, prompt the user to enter how many numbers they
will require, then somehow write a macro to pull the information over into
the word doc. (i am not sure how i would do this without presetting the Copy -
Paste Special)

b) write a word macro to auto erase the unused numbers after updating

Now option 'b' sounds like it would be easier to code, but i am not sure
where to begin with that.

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

You could automate the whole process. You could search for Requirements in
the excel workshhet and then take all the requirements in adjacent rows
leaving a blank cell after the last requirement. Then excel macro simply
needs to copy the information until it finds an empty cell.

"GainesvilleWes via OfficeKB.com" wrote:

Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
So i apologize if I missed the answer to my question.

I am attempting to develop an Excel worksheet that will ultimately pull the
data into a word doc using the Copy - Paste Special method.
What i am wondering is that in one section of the word doc is a Requirements
page. This page can have anywhere from 1 to 50 separate line items on it.
Each one is numbered, (1. 2. 3., etc)
Instead of just creating 50 numbered lines and using 50 cells in the excel
worksheet then going back after updating the information on the word doc and
deleting the blank numbers not used, can i either:

a) on the excel worksheet, prompt the user to enter how many numbers they
will require, then somehow write a macro to pull the information over into
the word doc. (i am not sure how i would do this without presetting the Copy -
Paste Special)

b) write a word macro to auto erase the unused numbers after updating

Now option 'b' sounds like it would be easier to code, but i am not sure
where to begin with that.

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

Nice. Thank you.
One question though: On the word document; how would i get each 'line item'
individually numbered?

Joel wrote:
You could automate the whole process. You could search for Requirements in
the excel workshhet and then take all the requirements in adjacent rows
leaving a blank cell after the last requirement. Then excel macro simply
needs to copy the information until it finds an empty cell.

Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
[quoted text clipped - 20 lines]

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

Include the numbers in excel.
1) Requirement A
2) Requirement B
3) Requirement C

"GainesvilleWes via OfficeKB.com" wrote:

Nice. Thank you.
One question though: On the word document; how would i get each 'line item'
individually numbered?

Joel wrote:
You could automate the whole process. You could search for Requirements in
the excel workshhet and then take all the requirements in adjacent rows
leaving a blank cell after the last requirement. Then excel macro simply
needs to copy the information until it finds an empty cell.

Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
[quoted text clipped - 20 lines]

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

I see what you are saying....nice.

You wouldnt happen to have a handy prewritten macro to search would you?

Joel wrote:
Include the numbers in excel.
1) Requirement A
2) Requirement B
3) Requirement C

Nice. Thank you.
One question though: On the word document; how would i get each 'line item'
[quoted text clipped - 10 lines]

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

I re-read your previous posting. No mention about any searches. You need to
be more specific what type of search you are requesting.

"GainesvilleWes via OfficeKB.com" wrote:

I see what you are saying....nice.

You wouldnt happen to have a handy prewritten macro to search would you?

Joel wrote:
Include the numbers in excel.
1) Requirement A
2) Requirement B
3) Requirement C

Nice. Thank you.
One question though: On the word document; how would i get each 'line item'
[quoted text clipped - 10 lines]

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1