NARAYANK991

E

• E

  EricaJan

• Jul 15, 2022

Hello Narayank991,

Thank you for VBA code to protect all sheets but allow Drawing Objects. I have been using the code for some time.

Would you be kind to let me know how to add additional allowance, Formatting Rows?

Here is the link to your code.

Would really apricate your help.

https://chandoo.org/forum/threads/macro-protect-all-sheets-but-allow-edit-objects.36209/

A

• A

  augustus

• Jun 10, 2022

need help in exporting excel to csv, we need " in each field when exported to CSV

P

• P

  prshiv

• Dec 25, 2019

Hi, Narayank991,

Need your help in making allocation macro for my team i have taken help from your macro here https://chandoo.org/forum/threads/work-allocation-to-team-members.36234/ but i am not able to understand few variables. I have to copy code to my macro. Please help .

Thanks,
Aman

M

• M

  Molly5

• Dec 9, 2019

Hi Narayank991 - you have helped me in the past (thank you). I am not sure where to ask this question so I am asking you where I should post it. Is it possible to create a document from the questions and your drop-down list of answers from excel? ex: I have answered all the questions from the drop-down, can I export the questions with the answer I have chosen to a word or PDF file? Thank you kindly for your help.

E

• E

  Esrabyl

• Apr 19, 2019

How Can I list only certain lines to another work sheet? Advance filter is not working! I have 100`s of Job numbers and 1000`s of invoice number. I need to copy certain job transactions into another worksheet. How can I do that?

K

• K

  Kishor Mhamunkar

• Jun 21, 2018

i Team,

I would like to get a macro code for the below activity.

I have bank statement in CSV format, my macro code code should read the close csv and get relevant data and create another csv and paste it there.


I have a database of account , account number and manageent company hence the code should only copy details for matching account from closed CSV .


Can someone please help me.

C

• C

  Chirag R Raval

• Apr 28, 2018

Dear Sir,

Can you little help here?

https://chandoo.org/forum/threads/thoug-finish-process-for-loop-not-initialised-error-display-on-some-weird-place-of-code.38336/

Regards,

Chirag Raval

A

• A

  AmitSingh

• Apr 23, 2018

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/

J

• J

  Jaime G

• Apr 3, 2018

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?

• 

  Rafay Ahmed

• Mar 19, 2018

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

E

• E

  Emcee

• Mar 5, 2018

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

S

• S

  S. Das

• Jan 11, 2018

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

C

• C

  Chirag R Raval

• Jan 11, 2018

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

C

• C

  Chirag R Raval

• Jan 6, 2018

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

P

• P

  PrashanthGM12345

• Jan 4, 2018

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

C

• C

  Chirag R Raval

• Dec 22, 2017

Dear Sir,

Can u have now little time for below thread?

Regards,

Chirag Raval

C

• C

  Chirag R Raval

• Dec 16, 2017

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

C

• C

  Chirag R Raval

• Dec 14, 2017

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

C

• C

  Chirag R Raval

• Dec 12, 2017

Dear Sir,

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

rergards,
Chirag Raval

C

• C

  Chirag R Raval

• Dec 12, 2017

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

C

• C

  Chirag R Raval

• Dec 1, 2017

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

A

• A

  abdulncr

• Nov 22, 2017

Dear Sir,
Can you help me please... vba code not working after upgrading office to 2016
https://chandoo.org/forum/threads/send-pdf-file-not-working-in-office-2016.36476/