$$Excel-Macros$$ Macro for collating information

2010-12-06 Thread Sir Digby Chicken Ceasar
Hi please help as this will save me loads of time I just recorded this macro but what I need it to do is pick the same set of info from different weekly sheets labled as the date in yymmdd format so for example I want this to start at 081031 and carry on to 101210 copying the range ("C136:DO136")

$$Excel-Macros$$ Help with pivot table

2010-01-13 Thread Sir Digby Chicken Ceasar
Hi Sorry for off topic as this has nothingto do with VBA or MACROS. Please could someone tell me how to change the source data range on a pivot table in excel 2007? I've set up a pivot table which sources data from a list but I've now added more to the list and don't want to have to re-make the