black head of table

[bogd1n]

TEST.xlsm

HELLO

I HAVE AN ANOTHER IDEEA
I NEED A TABLE (ATTACHAMENT)

THIS COLOMN I WANT TO INDEXING FOR EXAMPLE SOMETIMES I NEED ONLY COLOMN 9 SOMETIMES I NEED COULOMN 9 TO 17 AND MORE FOR EXAMPLE AFTER 20
I WANT TO REGENERNERATE AFTER I NEED ME BUT HEAD OF TABLE REMAINING A BLOCK
IN SHEET 2 I PUT A EXAMPLE I WANT COLUMN L TO R DISAPEAR BUT ONLY RED CELLS
head of table not is modificable

It is a way to realize this?

thkst1.jpg

[Richard Buttrey]

Hi,

You need to upload your workbook. Pictures like this are rarely much use, not least because it's unreadable.

When you upload your workbook add some notes that clearly explain how you use the workbook, which cells are original data and which cells are results that you expect. Manually add some typical results and explain EXACTLY how you calculate your results.

Then, and only then, will we have some idea as to what you're trying to achieve.

[Glenn Kennedy]

Richard - it's there. First line of the post...

[Richard Buttrey]

... so it is. Thanks Glenn, completely missed that.

Now all I need is for bogd1n to respond to the other points.

[bogd1n]

...other points :d

i want yellow color remaining a block (a kind of freeze)
and green color of couomn is same thing with insert coloumn but except the head of table
i hope i explain good

tks

[bogd1n]

more explicit

row 1,2,3,4,5,6,7 is one table and rest is another table

[Richard Buttrey]

Sorry but I'm struggling to understand what you mean.