Hello,
I have a column that has a formula inbeded in all of the cells that automatically gets populated with data from another sheet. What I am trying to do is create a graph on a seperate sheet with only the cells that have data in them by just clicking a button I made. I am not a good programer at all. Any buttons with macro in them I make I record. I can not figure out how to select the cells with only data in them to be put into the graph. Every time I try it selects every cell in the column that is populated with data and the empty ones with just the inbeded formula in them and includes them as zeros in the graph. This graph could have 4 cells to as many cells excel could fit that is why I need this macro to only select the cells in the column with data in them. I hope this is explained enough. Thanks!!
Bookmarks