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

Supress Zeros in a macro

M

Mortadella

Member
I have created a worksheet that produces statements for my customers. It feeds off a sheet that is upgraded from our accounting package so I have to refresh the formulas that pick up the line detail each time I import data.


That's no problem but many of the lines that are imported contain zeros and since I don't know where they will be I have to pick up all the info - that doesn't present a problem but each time I do a refresh of the data I find the lines that read the statement information have a whole pile of useless zeros.


I have saved the files with the zeros suppressed but each time I run this I find I have to do it again. I have no idea how to incorporate a "Supress Zeros" in a macro and can't seem to find out how in any of my references.


Does anyone know how to do it?
 
Mortadella


Can you post a sample of the data and also a sample of what it looks like when complete

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi Hui!


I'm sorry I haven't gotten back to you yet. I am unable to download the programs you have suggested so I can send you the sample data. I will do it at home on the weekend and get it back to you.
 
I managed to get it posted in HotFile https://hotfile.com/dl/197642716/8bee311/Sampleageing_(1).xlsm.html


This took some doing because I can't add programs at work and when I got home I couldn't get in here because my password wouldn't work and it's my work address that gets the update.


My apologies for the delay.
 
You must log in or register to reply here.
Back
Top