taking multiple inputs userform VBA

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!!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

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.
Go back
Back
Top