ardadogan
06-06-2007, 02:19 AM
hi,
although i subscribed only last week, this forum has already given me a lot of ideas i will use for my project. thank you for the inspiration.
now i will have a question. i don't know if it's feasible or it's been done before - tried to find help here and on the internet but couldn't find anything. would be glad if you could direct me to a source or give me your opinion.
here's what i want to do:
let's say i have a cell labeled WEIGHT in my workbook. value of the cell is 350 at the moment. and i have a date in a cell labeled DATE. and some other cells with different labels.
i can obviously type
=WEIGHT&" kgs shipped today"
to display
350 kgs shipped today.
i want to develop something that will insert the data from this cell whenever i type a certain string in any cell in the workbook : let's say
Dear @BUYER@,
@WEIGHT@ will be shipped on @DATE@ to @DESTINATION@ on B/L @BLNUMBER@ by @CARRIER@
to display
Dear John Smith,
350 kgs will be shipped on 23/06/2007 to Leixoes on B/L 5435245 by MAERSK.
typing
="Dear "&BUYER&"
"&WEIGHT&" will be shipped on "&"DATE"&" TO "&DESTINATION&" ON B/L "&BLNUMBER&" BY "&CARRIER&"."
isn't very convenient.
-
it doesn't have to do it when i push enter - i can type it and then run a macro using a keyboard shortcut to change the text into a formula by drawing the information from appropriate fields and concetenating the strings.
any idea how i can do it?
many many thanks -
arda
although i subscribed only last week, this forum has already given me a lot of ideas i will use for my project. thank you for the inspiration.
now i will have a question. i don't know if it's feasible or it's been done before - tried to find help here and on the internet but couldn't find anything. would be glad if you could direct me to a source or give me your opinion.
here's what i want to do:
let's say i have a cell labeled WEIGHT in my workbook. value of the cell is 350 at the moment. and i have a date in a cell labeled DATE. and some other cells with different labels.
i can obviously type
=WEIGHT&" kgs shipped today"
to display
350 kgs shipped today.
i want to develop something that will insert the data from this cell whenever i type a certain string in any cell in the workbook : let's say
Dear @BUYER@,
@WEIGHT@ will be shipped on @DATE@ to @DESTINATION@ on B/L @BLNUMBER@ by @CARRIER@
to display
Dear John Smith,
350 kgs will be shipped on 23/06/2007 to Leixoes on B/L 5435245 by MAERSK.
typing
="Dear "&BUYER&"
"&WEIGHT&" will be shipped on "&"DATE"&" TO "&DESTINATION&" ON B/L "&BLNUMBER&" BY "&CARRIER&"."
isn't very convenient.
-
it doesn't have to do it when i push enter - i can type it and then run a macro using a keyboard shortcut to change the text into a formula by drawing the information from appropriate fields and concetenating the strings.
any idea how i can do it?
many many thanks -
arda