Hui

Hi,
I need small info Hui,
I have modified "To Do list" from this forum to suit my requirement with VB interface. (http://chandoo.org/wp/2013/01/07/todo-list-with-priorities/).
Its helping me lot to maintain daily track. I hope this may help other members too.
I want to ask you, how to post this update template in Forum so other can take benefit.

Hui Can you please respond to my query? its about the mail merge. you had offered to help someone with a similar issue a couple of years back but he never sent you the file.

Hi Hui,

Let me just explain this way then:
=SUMIFS("'"&Reference&"'"!A:A,"'"&Reference&"'"!B:B,A20,"'"&Reference&"'"!C:C,Reference)

Reference is a "Name" changes in real time based on a List selection. I get an error in this. Any help is appreciated as this little urgent.

Regards,
Chine

Hi,
I m Ayyappan, I know the basic Mail Merge but I want to do mail merge with multiple row data for example:
Name Date of Absent Day
Mr. A 02-03-2016 Half Day
Mr. A 03-03-2016 Full Day
Mr. B 02-03-2016 Half Day
Mr. B 02-03-2016 Full Day
Mr. B 02-03-2016 Full Day
Mr. B 02-03-2016 Half Day

Need help to get
1.total of Join qty agst name of product in summary sheet from sheet 2
2.same as 1no of talal left qty
4.Batch code = which qty is available ( like in join sheet product A joining on dt 1feb-5,2feb-05,3feb-10 of differ batch code S1 ,S2,S3
then its left on dt 02feb -3,4feb -3,1feb-3 of batch code S1,S1,S2)
Batch code S2 & S3 should be shwng in Batch

I'm new to this site and I'm having a problem posting. When I post, I get an Error message and to try later. I'm trying to connect with someone for help. Can you help me with this issue

Hui, could you please enclose once again files to post http://chandoo.org/forum/threads/comments-in-charts.619/#post-162843 because I can't download it. Thanks in advance !

Hui, What does the following mean?

Robots connected: 25 (currently)

Hi Hui, I have emailed Chandoo, but I know he is a busy person ,,,, I purchased the Excel Wedding Planner file back in 2011 and my daughter announced a month or so ago that she is planning to get married next year, so I thought about using the wedding planner file, but cannot find it ( I think it's on an old corrupt laptop ), is there anyway I can purchase another copy of the full version that you know of? Thanks

Sir, Could you check my problem?

Hello Hui Sir, Please change / rename my profile name to "AK" only. In all previous & future post my name as "AK". This show every where in chandoo.org site. Thanks.

Hello, I am new here and wondered if you might be able to advise me on something "charting" related. I have already discovered the vast "trending" sections which I intend to investigate more thoroughly, but I thought I might pick your brain first to see if that is indeed the route I should even be going. Any help is appreciated.

Thanks

Hui, can you please change my settings so my posts don't require approval? As a moderator on other forums and fellow MVP I think you can trust me to behave.

Is there a way to send you a Private message with a good explanation? I know you can help but I can not afford the lottery commission to know what I am doing. Narayan has copies of my work and is beginning to understand and I do not mind if yall correspond as he knows Excel a whole lot better than I and so do you. I really appreciate all your help and I know my stuff is difficult for me to explain my apologies

hi hui pls help me to improve my excel skills... can u send me some data file where i can implement formulas..

Thanks
Manoj Singh

Dear Hui Sir, again apologies for requesting on post, kindly help me with the Interactive dynamic chart. I am pressured to give this at my office.
thank you so much.
with regards,thomas

Dear Hui Sir, Apologies for disturbing you on the post even after your request, I need help on the scroll bar chart, please help me, we need to send the presentation as soon as possible.
sorry for pushing you on this.
thanks,
thomas

Hi Hui,

Hope you are doing well. I haven't been able to spend much time online, but I got one of your posts (http://chandoo.org/wp/2015/03/27/conditionally-format-chart-backgrounds/), and thought I'll share one more solution.

But I don't know how to attach the file. If it's fine with you, I can post one in the vault.

Hi Hui

tried to extend the formula for more years but for some reason it doesnt seem to pick up the correct value after a certain number of years. Sorry i am posting here as i am not sure if my reply in the orginal post will send you an alert.

http://chandoo.org/forum/threads/formula-to-pick-up-value-from-another-cell-and-delay-by-a-year.21950/#post-133165

Thanks for your help again

Oh!! Sorry .Read ur post after posting.. Sorry for directly asking.

Hello Sir , i have posted one question. Can you please help me out. It is realted to creating the dynamic vertical line with excel macro whenever i click mouse or any shotrcut key.

Sir could you please check my topic? I tried to find a solution via Chandoo site and also other sources but I couldn't find a solution. I need an expert help.. Thank you.
=>
http://chandoo.org/forum/threads/how-to-create-generate-a-licence-code-for-my-excel-file.22002/

hello, could you please help me with this topic
http://chandoo.org/forum/threads/help-with-this-sheet.21873/

Hello Hui.. Good morning from India.. can i please request you to have a look at following VBA post. I have expecting answer from past couple of days.. many thanks in advance..
http://chandoo.org/forum/threads/macro-to-send-custom-excel-file-via-outlook-with-custom-body.21660/

Thanks for your explanations.. Very appreciated..