THE_NEW_XL_GUY
New Member
- Joined
- Dec 20, 2017
- Messages
- 47
I have multiple csv/xls files that i want to browse from user form then get specific cells data from them and copy to specific cells of already present workbook with formulas which want to browse again from user form and get output to a folder.
I have multiple batch of 4 files in which i need only specific cells to be copied to one master book specific cells.
example: a.xls b.xls c.xls d.xls. Giving this as input from userform and copying to specific cells of masterbook cells again providing next batch of 4 files e.xls f.xls g.xls h.xls in same userform and copying to different set of specific cells in same masterbook.(used radio buttons for this to act as template for batch of files.
Am basically a programmer but noob in VBA. kindly help me with this. thanks aton first!!
I have multiple batch of 4 files in which i need only specific cells to be copied to one master book specific cells.
example: a.xls b.xls c.xls d.xls. Giving this as input from userform and copying to specific cells of masterbook cells again providing next batch of 4 files e.xls f.xls g.xls h.xls in same userform and copying to different set of specific cells in same masterbook.(used radio buttons for this to act as template for batch of files.
Am basically a programmer but noob in VBA. kindly help me with this. thanks aton first!!