New profile posts

Hi sir, need help to grouping the cell values on one cell to another cell by matching the criteria. For example, if XYZ value is given in continues 3 rows then their value should be grouped as 1,2,3 in another column of same row where the XYZ is there.
https://chandoo.org/forum/threads/grouping-of-cell-value-from-one-cell-to-another-cell-by-matching-criteria.38277/

Hi sir, need help to grouping the cell values on one cell to another cell by matching the criteria. For example, if XYZ value is given in continues 3 rows then their value should be grouped as 1,2,3 in another column of same row where the XYZ is there.
https://chandoo.org/forum/threads/grouping-of-cell-value-from-one-cell-to-another-cell-by-matching-criteria.38277/

I don't know whether I can write here to you directly or not. But want to say thank you for your help. But still a small problem is there. I have explained problem in same post.
Can you please help?

Hi Sir, I got difficulties in pasting the column values from one workbook sheet to another workbook sheet. I have provided the link.
https://chandoo.org/forum/threads/copy-column-cell-values-from-one-workbook-sheet-to-another-workbook-sheet.38237/ please it would be great help. Thank you.

Hi Smallman, stuck in code to copy the cell value from workbook sheet to another workbook sheets of column by matching 3 criteria with both the workbook sheets, if criteria matched then copy the same row value another column to other workbook sheets...Thanks. Below link of question.
https://chandoo.org/forum/threads/copy-the-cell-value-with-matching-multiple-criteria-from-two-workbook-sheets.38197

Hi, stuck in code to copy the cell value from workbook sheet to another workbook sheets of column by matching 3 criteria with both the workbook sheets, if criteria matched then copy the same row value another column to other workbook sheets...Thanks. Below link of question.
https://chandoo.org/forum/threads/copy-the-cell-value-with-matching-multiple-criteria-from-two-workbook-sheets.38197

Hi I'm Jamie. I have daily files with data and I have to run some macros on that daily files. Today, I am copying the macros on each file to run and I would like to have the macros in one file (as code source) and run the macros from that file and acting on the daily files. File 1 has all the macros only and file 2,3 have the data so I open file 1 and run the macros to modify files 2,3..
Could you assist please?

Dear Sir, Apologies I couldn't reply you that day. Yes your solution was right to my post, https://chandoo.org/forum/threads/comparing-the-column-and-highlighting-the-same-number.37745/#post-226706, can you teach me if I want to apply that to a large set of data.

Thanks you so much

Regards,
Rafay

Dear Sir, I'm currently trying to work around a similar problem in this post https://chandoo.org/forum/threads/to-repeat-row-values-a-specified-number-of-times.12985/

I tried the solution of Sajan but it returns some errors in my case. Could you help me with that?

Thank you so much!

This is the sample file link: https://drive.google.com/open?id=1qAHDHlp8J-5UmtvEM-Zdu9M48DObho9jIM1ZcMUHZFw

Regards,
Quan Nguyen

Hi Luke,

Is there a way to use Powerview reports without Silverlight?
Also, how can we keep the interactivity on the mac?

If the above both are not an option, is there a way to export the excel powerview report to a webpage?

Thanks,

Madhu

Dear Sir, Can you please help me in that
https://chandoo.org/forum/threads/custom-function-not-giving-desired-result.36943/

Dear Sir,

Some twisting found on post no 50

https://chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/page-2#post-221388

Can you focus on that, if possible?

Regards,
Chirag Raval

Dear Narayan Sir,

Can I hope something - little help from you?
https://chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/page-2#post-221388

Regards,

Chirag Raval

Hi Narayank991. I have a query can you please help me. I tried to add hyperlink to hidden sheets but its not working. i am struck can you help me with this. i tried with the code which you sent but it didnt work for my excel

Here is the link of my excel file

https://chandoo.org/forum/threads/adding-hyperling-to-hidden-sheets.36863/#post-221245

Dear Sir,

Can u have now little time for below thread?

Regards,

Chirag Raval

I am looking to Sync my Excel File to Google Docs in Real time,
Can u Work on it ,Let me know your price

Dear Sir,

Code obtained from your helping -forever code..

https://www.chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/#post-220089

where I made mistake in this code? please help..
Regards,

CHirag Raval

Dear Narayan Sir,

Its just required as reverse of your successes & working code..

https://www.chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/#post-220089

mentioned in Post No 23..

Regards,
Chirag Raval

Dear Sir,

Thanks for your reply..
I try as per your suggestion..

rergards,
Chirag Raval

Dear Sir Narayank

you can help me on ...
https://www.chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/#post-220081

Regards,
Chirag Raval

Dear Sir,

hope you can fill hole in this code.. little help required..
https://chandoo.org/forum/threads/loop-all-files-in-folder-search-for-instance-copy-each-entire-rows-in-active-sheet.36501/

Regards,
Chirag Raval

Can you help how to export only body of an email from a specified folder of outlook to MS Access