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.
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
