Transferring data from 5 excel files to 1 new excel sheeet

So you want specific data, not the whole lot?

Hi

you can use this code to pull info into one sheet, just alter ranges/column numbers/ sheet names etc. Just copy into a standard VBA module and assign macro 1 to a button.

Please Login or Register  to view this content.

hope it helps

Theres no need to waste money on phone calls just post here and if not me someone will pick up your question. I do this in my spare time from work (of which i have very little due to been in the crazy world of management infomation) so i am not always around.


Alt-F11 is the shortcut key to open the vba (Visual Basic for Applications (similar but the same as Visual basic 6).

Insert > Module > Then just copy and paste the code in.

Close the editor 9save if you like but dont forget to save the workbook as well.

Now you can create buttons two ways, using buttons or autoshapes. The nice thing about buttons is they have that click effect. Then again you are limited to rectangles. With autoshapes you can create a wide number of different looking buttons, circles, squares, stars etc, however they dont have the click effect.

Its handy to have two toolbars open at this point

view > toolbars > forms (button toolbar) and drawing (autoshapes)

now when you create a button it will ask you to assign a macro, autoshapes dont but right click then assign macro.

make sure you close the vba editor down before you run as it wont run in break mode (Editing)

Hope it helps