Hi,
sorry for that, To be clear i have used Hyperlink(Vlookup(Link), Vlookup(Friendly name)) in Column C & D to get a link from another sheet, now i want this result without formula, i want to submit a final report file without formula but with links. I tried paste special options but the...
Hi,
I have a hyperlink formula in column C & D, i just want to paste these formulas as values with link. In short, i want to remove hyperlink formula but not the link associated to that cell.
Please help
Thanks
Sridhar
Hi All,
I have different sheets in my workbook for which i have different passwords with which i need to protect each sheet with the password assigned to it.
Is it possible to do a macro which automatically protect the sheets with the correct password
I have attached a sample workbook the...
Hi SirJB7
Thanks for your response
I am very new to this site ... i tried searching it but not able to find it.
It would be better if you could help me on this issue
Thanks
Hi,
Greetings for the day !!!
I am trying create sheets using template based on unique value and I want those datas to be pasted in respective sheets
Now I got some code which is creating sheets perfectly but I want to create sheet using template and I want the data should be pasted in range...
Hi Luke M
I have lot of charts to display so i think presenting in excel will not be possible ... is there any vba code for powerpoint which will refresh the data on each slide in the presentation ...
Thanks
Sridhar_shri03
Hi Luke M
Thanks for your response
It worked but i want the chart to get updated automatically even when the slide show is running ...
Please help
Thanks
Sridhar_shri03
Hi,
I need to create a chart in a powerpoint with the data available in excel from a drive when ever there is a change in the excel there should be a change in the chart.
Pleae help
Thanks
Sridhar_shri03
Hi SirJB7
Thanks for your response
But i want the table as format in the below picture
http://www.mediafire.com/download.php?hmwcnv616a5w6a5
Pls help
Thanks
Sridhar
Hi SirJB7
Thanks for your response ...
I want the data to be displayed in table as:
Title Title Title Title
Value Value Value Value
I tried reording the statements but i am not able to get the output
Could your pls help
Thanks
Sridhar
Hi Narayank991
I have already tried this code but it is not inserting the % character in the variable msg
It is adding ? instead of % in variable character
Pls Help
Thanks
Sridhar
Sorry for the incovenience
I am new to the site i dont know how to upload the files
the following is the mail format i need to get
Hi Sridhar
U will get the bonus
Bonus productivity rating 1 rating 2
400 4000 5 4
(the above as table)
Regards
Sridhar
The excel...
Hi Narayank991
so if my question is not clear
I need to get percentage character "%" in the output
I tried using chr(37) and Inserting "%" text in vba coding but both of that didnt work
Thanks
Sridhar
Hiii
I need to get a percentage character in VBA
Actually i have a code which will send personalised mail for each and every one, in which i have productivity information of my team which is picking correctly but the problem is i am not able to get the "%" character after the productivity...
Thanks for your response
But the code didn't work, i need to get a table with its header as first row and tables another row as information available in each row for that receipient ...
Pls help ...
Hiiiii
i have an issue if solved much appreciated
I am an BPO Employee i have to send monthly ratings to my team members, by personalised mails to each and every one in my team with the data available in excel
for Ex:
In column A i have name of the team members and in Column B i have...