• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

New profile posts

What's new New posts New profile posts Latest activity
Hannan Hussain
Hi Narayan

good afternoon.

We are looking to create an excel templet to get the cost estimation of any printing job. I am working for a printing press and the estimation system here is manual, which i need to move to excel automation. I can share you some video link available on youtube which will give an idea what we are expecting.

Please let us know, if you can create if for us.

Thanks
A
need help in exporting excel to csv, we need " in each field when exported to CSV
A
augustus
Public Sub ExportWorksheetAndSaveAsCSV()

Dim fn As String

fn = "_" & Format(Now, "yyyymmddhhmmss")

ThisWorkbook.Worksheets("Data").Copy

With ActiveWorkbook
Application.DisplayAlerts = False
.SaveAs Filename:="C:\TMU-Export\TMU_Sales" & fn, FileFormat:=xlCSVUTF8
Application.DisplayAlerts = True
.Close savechanges:=False

End With

End Sub
A
augustus
this is what we use for exporting to csv with date & time stamp
A
arifanmol
is there any way to automatically sum the cells and with automatic change in data range as the cells decrease or increase
A
Hi Luke,
Hope everything is great there!

I really need your help with my recent forum post. It seems easy at first, but somehow is beyond my excel skills.

Client wise Sales Commission Calculation (Tiered, Variable and Fixed - All in One)

Hi all, Hope you are doing great. I am facing a seemingly easy yet frustrating challenge. I have a client wise multiple commission approaches i.e. Fixed, Variable, Tiered. (Mentioned as commission types) Fixed is flat fee yearly. Variable is sales * variable percentage (simple) Tier wise is...
chandoo.org

Can you please have a look and check if this is possible?

Many many thanks!

Regards,
Amit
M
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.
MAKFADEL
Hi Deepak, Dear Sir , i would like some help for this small lotto application if it is possible i will pay you, thank you in advance.
Deepak
Deepak
Hey, Share me the link, if will help if i can
E
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
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?
E
Deepak - do you provide consulting work. I have some Excel formulae to write. I will pay you. How can I reach you?
Deepak
Deepak
Send me a private message.
M
maniniinfotech
hi am very new this excel and vba i need a formula to find the difference between two cells,and it should highlight the two cells based on the output value i have created if statement find the difference and output will be other cell "=IF(I1>=H1,(I1-H1),(I1+10)-H1)"
Purbani
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,
AlanSidman
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
Monty
Wishing you a very Happy Birthday Deepak...God Bless you. Have a wonderful year ahead.
K
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
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.
Back
Top