New profile posts

E

• E

  Esrabyl NARAYANK991 Esrabyl wrote on NARAYANK991's profile.

• 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

  kabanda Luke M kabanda wrote on Luke M's profile.

• Apr 13, 2019

I have just started learning VBA with excel and still finding challenges especially how to update the spreadsheet with marks against student names using text box in userforms. Can I find assistance?

K

• K

  kabanda Luke M kabanda wrote on Luke M's profile.

• Apr 13, 2019

Thanks for being registered..

E

• E

  Excel-Access Deepak Excel-Access wrote on Deepak's profile.

• Mar 8, 2019

Deepak - do you provide consulting work. I have some Excel formulae to write. I will pay you. How can I reach you?

W

• W

  webmax shrivallabha webmax wrote on shrivallabha's profile.

• Feb 28, 2019

hi can u provide the solution for transpose data

• 

  Purbani Faseeh Purbani wrote on Faseeh's profile.

• Dec 10, 2018

Hi Faseeh - I am looking for a copy of your Violin Plot example - would you be able to email me a copy please - peter.urbani@gmail.com

Many thanks,

G

• G

  Geeta Dharod keymaster Geeta Dharod wrote on keymaster's profile.

• Oct 24, 2018

i want to know how can i make housi ticket
with excel

• 

  AlanSidman r1c1 AlanSidman wrote on r1c1's profile.

• Oct 23, 2018

Chandoo, I know that you have in the past been in contact with Mike Alexander of DataPig. I am having difficulty opening his Blog. Do you know if Mike has shut down his sites or if not, then I will have to determine why my PC does not let me access his sites. Appreciate your input on this matter. FYI--enjoyed your interview with Mike a few years back.

Alan

D

• D

  dougj123456 r1c1 dougj123456 wrote on r1c1's profile.

• Aug 20, 2018

Hello I purchased the excel project dashboard last week can you please send

• 

  Monty Deepak Monty wrote on Deepak's profile.

• Aug 19, 2018

Wishing you a very Happy Birthday Deepak...God Bless you. Have a wonderful year ahead.

K

• K

  Kishor Mhamunkar Deepak Kishor Mhamunkar wrote on Deepak's profile.

• 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.

K

• K

  Kishor Mhamunkar NARAYANK991 Kishor Mhamunkar wrote on NARAYANK991's profile.

• 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.

R

• R

  rajkenya1 shrivallabha rajkenya1 wrote on shrivallabha's profile.

• Jun 13, 2018

Thank you so much for your recent help. You saved my day.

C

• C

  Chirag R Raval NARAYANK991 Chirag R Raval wrote on NARAYANK991's profile.

• 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 NARAYANK991 AmitSingh wrote on NARAYANK991's profile.

• 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/

A

• A

  AmitSingh Smallman AmitSingh wrote on Smallman's profile.

• 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/

A

• A

  AmitSingh r1c1 AmitSingh wrote on r1c1's profile.

• 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/

• 

  jb Luke M jb wrote on Luke M's profile.

• Apr 19, 2018

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?

A

• A

  AmitSingh shrivallabha AmitSingh wrote on shrivallabha's profile.

• Apr 19, 2018

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.

A

• A

  AmitSingh Smallman AmitSingh wrote on Smallman's profile.

• Apr 16, 2018

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

A

• A

  AmitSingh ThrottleWorks AmitSingh wrote on ThrottleWorks's profile.

• Apr 16, 2018

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

J

• J

  Jaime G NARAYANK991 Jaime G wrote on NARAYANK991's profile.

• 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 NARAYANK991 Rafay Ahmed wrote on NARAYANK991's profile.

• 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 NARAYANK991 Emcee wrote on NARAYANK991's profile.

• 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

M

• M

  MadhuKashyapa Luke M MadhuKashyapa wrote on Luke M's profile.

• Jan 31, 2018

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