hi my situation here is i have 16 excel files full of information and i want to import all their details into a new excel file. can u provide the code for me please? much appreciated.
Probably not, but here's a starting point:
Open the "new" spreadsheet.
Turn on the macro recorder.
Open one of the 16.
Manually perform the steps you want.
Stop the macro recorder.
Using Alt-F11, look at the code that was created.
Ask a specific question if you still need to.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.