Code to exclude cells returning zeros

[Keletso]

I am preparing a monthly payment report for 12 departments which requires information from various sources. I use one file to Lookup and calculate and transfer the transformed data into each department's model. However payment reports are not the same volumes (some has more cells others has less cells)

When i copy i want to exclude those cells that returns zeros

 

[vletm]

You could filter needed data.

Please reread How to get the Best Results at Chandoo.org from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[Marc L]

However payment reports are not the same volumes (some has more cells others has less cells)

Very not a concern as when executing any VBA procedure all is static under Excel !​

For smart worksheets see UsedRange … For others another VBA help must see : CurrentRegion !​

​

In case of an Excel table just see its specific properties.​

​

When i copy i want to exclude those cells that returns zeros

For a smart fast efficient direct way just use an advanced filter ! (can't be used with an Excel table but the below …)​

​

For beginners the indirect way : as the Excel Copy feature copies only the visible cells then,​

as already advised in the previous post, just filter the data before …​

​