Copy Column D from all worksheets in WB1 and paste in sheet1 WB2
Hello
I need help with code.
I have Workbook A with 70+ worksheets, and I want to copy contents from
column D from each worksheet and paste in Workbook B Sheet1 so that it looks
like:
Column C Column D Column E Column F
Col D sht1 Col D sht2 Col D sht3 Col D sht4
and so on.
Is this possible?
Please help me.
Thanks & regards
farid2001
|