Consolidating Data [Closed]

Report
-
Hello,

I have an excel worksheet that I am attempting to publish easily by automating the recovery of certain data. My goal is to add the text of each cell to which the cell to the right has a value greater than zero. The caveat is that I want those cells (whichever they may be) to copy into the same five to 10 cells on a different sheet. Is there a way to do this?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!