Hi All,
Can some one help in automating the notepad data replacement.
I have data of 6 columns and 2 rows that consists of names and numbers count,
and I have a date in my notepad along with same components that are in excel.
I need to automate like when ever I had updated values in excel when I add those details in excel sheet that should open note pad and replace those values.
example:
in excel: a=10
b=4.0005
c=7.998
dd=6.4
in notepad
my name is kind and my data is xxxxxxxxxxx
xxxxxxxxxxxxxxx
a=9
b=5
c=8
dd=7
my data xxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxx
so data from excel has to select/search that particular matching words and replace values exactly that have entered in excel sheet.
can some one please suggest me any automation that I can do to make it updated when ever I get data
thanks and most appreciated for help
kk
Can some one help in automating the notepad data replacement.
I have data of 6 columns and 2 rows that consists of names and numbers count,
and I have a date in my notepad along with same components that are in excel.
I need to automate like when ever I had updated values in excel when I add those details in excel sheet that should open note pad and replace those values.
example:
in excel: a=10
b=4.0005
c=7.998
dd=6.4
in notepad
my name is kind and my data is xxxxxxxxxxx
xxxxxxxxxxxxxxx
a=9
b=5
c=8
dd=7
my data xxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxx
so data from excel has to select/search that particular matching words and replace values exactly that have entered in excel sheet.
can some one please suggest me any automation that I can do to make it updated when ever I get data
thanks and most appreciated for help
kk