macro help

  • Thread starter Thread starter nims_2k1
  • Start date Start date
N

nims_2k1

Hello All
I have a excel sheet with some calculations on the first page, no
I need to create a report or cover sheet that I need to send. It need
to be in the text format and it needs to pull a few numbers from th
excel sheet.
ex:
excel sheet info
number of pymnts : 40
payment amount : $500
and so on...

in the report on the next page I need to write a text statement ex:
The total of 40 payments of payment amount $500 needs to be received b
the person ....

How can I get the 40 and $500 populated in between the strings??and i
needs to change every time the field on the excel changes. I am new t
writing macros and if this can be achieved any other way like usin
functions thats great. I have tried the concat and cell() function
but I am having a lot of formatting issues.

-
 
How about this:

On your first page
A1 = The total of
B1 = 40
A2 = payments of payment amount $
B2 = 500
A3 = needs to be received by the person ....


On your second page
A1 = concatenate(A1,B1,A2,B2,A3)

Note that the $ is in the text string in A2 and watch your spaces
 
Thanks for the update but I cannot have the words in the excel sheet.
want a paragraph on the report in a text format with the number
included from the specified cells.

-
 
Back
Top