techishawn
New Member
My excel and word file is in same folder.
My excel file consists:
Name Amount
John $1
Mary $2
Gary $3
[button]
Let say I highlight John and $1 - this 2 cell and press the button, it would open up word.
Not only these 3 entries(not hardcoded), user could add in more entries. So I have to target A1 to end, similarly for B1 to end.
My word file :
$Name
$Amount
left
I would set a default template style , $Name will be bold left align etc. For the variable it would automatically replace with "John" value from excel.
I am new to macros, unsure how to add in macros, hope you can guide me too.
Thank you.
__________________________________________________________________
My excel file consists:
Name Amount
John $1
Mary $2
Gary $3
[button]
Let say I highlight John and $1 - this 2 cell and press the button, it would open up word.
Not only these 3 entries(not hardcoded), user could add in more entries. So I have to target A1 to end, similarly for B1 to end.
My word file :
$Name
$Amount
left
I would set a default template style , $Name will be bold left align etc. For the variable it would automatically replace with "John" value from excel.
I am new to macros, unsure how to add in macros, hope you can guide me too.
Thank you.
__________________________________________________________________
Mod edit : thread moved to appropriate forum !