hello,
I want macro for copy data from multiple(nearly 100) workbook placed in one folder to one master workbook with detail bellow.
All work books having sheet name "list" from that sheet I want to copy cells C9, H9, H10 and H24:H29 from which H24:H29 contains formulas but in master work book i want to copy values only, I try many macro but any available macro not fulfilled my requirement.
please let me know if you require any clarification
Thanks
I want macro for copy data from multiple(nearly 100) workbook placed in one folder to one master workbook with detail bellow.
All work books having sheet name "list" from that sheet I want to copy cells C9, H9, H10 and H24:H29 from which H24:H29 contains formulas but in master work book i want to copy values only, I try many macro but any available macro not fulfilled my requirement.
please let me know if you require any clarification
Thanks
