$$Excel-Macros$$ SUMIFS

"< 40666",'1- DIARY'!$J$9:$J9954,"HolidayN") Can it be done? Thanks in advance. Regards Gerry. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$Excel-Macros$$ My dates are stored in various text formats in single column...Clever solution required.

would be most appreciated. Thanks in advance Gerry -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.f

$$Excel-Macros$$ Clever way to transpose required

I have a large spreadsheet (say 3000 rows with 60 columns). Not all cells are populated. Using that data I want to create a single column capturing all of the data. The number of rows will equal the number of pieces of Data. Help. Thanks in Advance Gerry

$$Excel-Macros$$ Copy Pivot Table Filters through code

o another pivot table :( any ideas ? greetings Gerry --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads