how to use a macro to consolidate data

[ss]

I am not able to consolidate data from different sheets which has to be done repeatedly for different ids. Need a macro to run to delete the prvs consolidation and get a new consolidation to take place.

 

[PaddyD]

Hi ss,

2 suggestions:

1) turn on te macro recorder & record yourself doing the colnsolidation once. see if you can generalise the code for future use

2) post lots more info. To the best of my knowledge, there are no mind readers here! The answer to the question "can anyone here write a macro for consolidation' is yes. The answer to the question 'Can anyone help me with a consolidation macro for my problem' will depend onhow much detail you give us...


Paddy