Delete unwanted columns

Originally Posted by stevekirk

hi,

in row 7 from column E i can have various number of dates of which
one of the dates will be todays date. the date the macro was run

i need to leave only 6 more columns after the todays date . as that is all i have to report on. therefore the others after the 6th column can be deleted then sum the 6 columns in the 7th column

there could be lots of rows

the dates before the todays date will stay

thanks

steve

That it is 10:52pm Saturday could be the reason for my confusion, so I need to ask, the '7th' column, is that column G or the 7th column after the column which is thought to contain todays date. Do the 6 columns following the column thought to contain todays date, and the columns before said column, contain data or dates?
If they contain data will that data be confused with a date (ie, numbers in the 38000 range?
Or does your phrase " in row 7 from column E i can have various number of dates " mean to say that the dates go 'down' column E from row 7 onwards?

Perhaps a small example of your data, and a small example of the expected outcome (as a .zip of your sample .xls) could help here.

---

hi,sample attached

steve

hi,

thats great all looks good, if possible can we hide the columns from e to todays date
thanks steve

The attached SampleC should be close enough to your deletion for you to use.
After you have tested this (and removed the displays as required) you will be able to add the line to hide columns, the format is

Please Login or Register  to view this content.

hth
---

Thanks Byran for all your help

steve