Referring to column without cell range

[meg9696]

I want to automate a spreadsheet data such that:
1. I cut and paste into first sheet some date
2. The second sheet has formulas that execute on the dataset in the first sheet.

The problem I have is that I want to refer to columns in the first sheet without providing a start and finish range, since this could be different depending on the amount of data in first sheet.


One of the formulas in the she second sheet is : =COUNTIFS(Y2:Y47,">=0",Y2:Y47,"<=50")
I would not know the range of column Y, is there a way to refer to that column in another way. Also how can the end of the dataset be known to the formula?

Appreciate any help and pointers. Thanks!

 

[meg9696]

file:///Users/mesharma/Desktop/Screen Shot 2015-12-14 at 5.40.44 PM.png

 

[meg9696]

Sorry everyone, I cant figure out how to upload a screenshot on my desktop!
When I click the image icon, I see insert image but o way to browse to desktop and upload an image.

 

[Peter_SSs]

Sorry everyone, I cant figure out how to upload a screenshot on my desktop!

You can't. If you need to show an image you can upload it to a public file-share site and then provide a link to there.
However, from my understanding of what you are asking, I don't think we need to see it.

Am I right in thinking that the "second sheet" has some formulas that draw data from TPM_Q3 (& perhaps other places too) and you want to have a pie chart of that information.
If that is correct, then can't you manually create the pie chart and it will automatically update when your formulas update after you paste new data into TPM_Q3?

If that is not the case then I think you will need some vba code, and I'm afraid making charts via code is not an area that I am very skilled in so hopefully somebody else might step in.