How to display a certain number of rows based off of a cell value...

[chindel]

If I want to display row values 1-30 when the cell value is 30 or 1-10 when the value is 10, what function do I use for that? Thanks in advance.

 

[Joe4]

Welcome to the Board!

This will require VBA.
Where does this Cell with this number reside?
Are all the rows hidden or unhidden by default (so is our VBA hiding or unhiding rows)?

 

[chindel]

Not sure if this image works, but I'm trying to display only the information on the table that is at or below the number of years entered.

I am unfamiliar with VBA, does that mean turning on Macros and writing formulas?

Thanks for the welcome!

 

[Joe4]

Your image didn't come through.
You can post images using the tools described here: http://www.mrexcel.com/forum/about-board/508133-attachments.html

Yes, using VBA means enabling macros and using VBA code.

 

[bschwartz]

If you just want to hide the data (as opposed to hiding the ROWS), you might be able to use conditional formatting. For example:

Excel 2010
	A	B	C	D	E
1	Date	Sales		Rows to Display	10
2	1/3/2013	20521
3	1/7/2013	6463
4	2/22/2013	16652
5	3/11/2013	21588
6	3/13/2013	9201
7	3/15/2013	7457
8	3/21/2013	15166
9	5/5/2013	21740
10	5/9/2013	9176
Sheet75

Excel 2010
	A	B	C	D	E
1	Date	Sales		Rows to Display	30
2	1/3/2013	20521
3	1/7/2013	6463
4	2/22/2013	16652
5	3/11/2013	21588
6	3/13/2013	9201
7	3/15/2013	7457
8	3/21/2013	15166
9	5/5/2013	21740
10	5/9/2013	9176
11	5/13/2013	7171
12	5/26/2013	20230
13	6/2/2013	9461
14	6/2/2013	10196
15	6/4/2013	15352
16	6/12/2013	24278
17	6/12/2013	9973
18	6/14/2013	11304
19	7/7/2013	5900
20	7/8/2013	6104
21	7/8/2013	19098
22	7/21/2013	6676
23	8/10/2013	10070
24	8/18/2013	21689
25	8/28/2013	9536
26	9/4/2013	13254
27	9/25/2013	9163
28	9/28/2013	23310
29	9/30/2013	7033
30	10/7/2013	18173
Sheet75

Instructions:
1) Highlight all cells by using the keyboard shortcut Ctrl+A.
2) Go to Conditional Formatting --> New Rule --> Use Formula
3) Enter this formula: =ROW(A1)>$E$1
4) Select Format --> Go to Number tab --> Custom
5) In the type box, delete the contents (such as General), and type ;;;
6) Click Ok, and Ok.