Hello , i need to create a master file that pulls data from others that have always the same Colums Format. The number of rows can change.
Im attaching an excel wich contain what i need to do. The sheets name are the same in every file i have to pull info. The files names where i have to extract the information are for example "Caja "& "14-10-2014" (dont know if this is needed)
What i want in the master file is all the transactions together in the same table. (the 2 sheets have different info , so i need 2 tables) The master file table has the same format as the files were i extract the info.example.xlsx
Im still new with vba if someone can help me it will save me lot of time : )
thanks