Automatically Deleting Columns In a 1M column spreadsheet

[garethuk81]

Hi Forum,

I have an excell spread sheet containing just over 1 million columns.

The spreadsheet is largely about statistics and each column has a time/date field in Column A, along with a number of rows next to it

Every (lets say 200 columns) there is a break in the data and subsequently different data held in a field belonging to previous data

after lets say (50 columns) the data is change back to the same type of data that was entered prior to the break.

This occurs every so many rows and I want to automatically set a rule/macro that deletes these 50 columns so that the I want is the same type throughout the entire workbook.

To put things in basic terms, if i was to write an AVERAGE=D4:D1202939 then it will get jumbled up with the other data that is entered after every 200 columns. Therefore i need to delete that additional data so that it flows all the way from D4 to D1202939.

Hope that makes sense and hope someone can help as it would take me weeks, if not months, to manually remove each section.

Thanks

Gareth.

[alansidman]

You speak of columns, but in your average formula, it appears that it is a row issue and not a column issue. Please clarify. Rows go up and down. Columns go across in Excel. Which are you referring to?

[garethuk81]

Hi,

Sorry. Basically i want all the data out of K1 to Kxxxx but every x many rows there is a section of data that is added and populates the K field with different data and continues for lets say 20 entries. Then after the 20 t populates with the data i want. this process is repeated throughout the 1M entry document. So basically i just want it to delete 20 rows every 100 rows in the workbook. Otherwise i will have to go through these sections and delete the data and line up the data again so it continues consistently.

Hope this makes sense :-)

[garethuk81]

So K4 to K156 contains data i want. then i want to remove data from K157 to 300. then delete the data from K301 to K400

The actual field numbers stated are not correct, but basically i want the data for every 100 columns, then remove the next 100 and then keep the following 100 then delete the next 100..... All the way through the 1,000,000 column worksheet.