table header

Okay, so i have a huge table which is roughly about 300 columns long. most of the headers are dates. What i need is that i change only the starting date of the project and the table headers automacially update accordingly. i would do it simply with "=(cell left to the chosen cell)+1". But that...

Hello, I am having a problem with my macro filling down the data properly. I have a table wit headers set up. My macro selects two cells in the first row, and tries to copy it down into the other rows of the table. Instead what happens, the macro copies down the table headers into the two cells...

I want to convert an array in excel back to normal cells. That is, I want to remove the header row / or undo the "format as table". Anyone know how to do that?

Hi All, This may seem a silly question, but I have created a table and Excel formats the data set nicely and adds filters etc, however in my Table Headers I have months, Jul-2013, Aug-2013 and so on. Now when I click and drag Aug-2013 to the right, hoping it will auto-fill with the value of...

Hi all, was working on this problem AGES ago, and could never find a simple solution. i'm SURE there has to be an easy way to do this, it would only make sense given the scenario. Scenario: Userform with 5 x textboxes. a NAMED 5 column table "Table1" that has headers, obviously real data...