multiple workbook

Hello, I'm using Excel 2013. I've got many workbooks in a folder. I want to open all these workbooks one by one, run a macro, save the workbook & close it. I do not want to specify the names of the workbooks in the folder so that I can simply add / remove workbooks in the future without having...

I tried to look for solutions for this. I was able to find stuff on copy data from multiple files into one, but what I want to do is copy a range of data from a workbook, paste it into a template, save as a new file, and then repeat for more workbooks in a folder. Here are some things that may...

Heya, I'm having an issue getting an array of cells that (the contents and range of which can change rapidly) from one work book to another and getting some quite strange results. Firstly I tried to just copy over the entire thing but it seems that the two workbooks have different formats or...

Master worksheet showing a list of consolidated data , specifically daily sales ranging from first of the month to last day of the month. Master worksheet Column A has dates, Column B has cash totals, column C has Credit card totals. Column B and C ref sales totals pulled from different...

Hello Please can you help urgently....? I need to send out hundreds of spreadsheets to individual people within my company, and would usually do this by pivoting the data, splitting this out into separate worksheets (by manager name), and then using a macro to split the worksheets into separate...

I have set up a workbook with sheets named for each month. I have 70+ separate excel files (one for each month) that each have a single sheet I want to copy into the new workbook's corresponding month sheet. Each file is named different but the name of the sheet in those files that I need will...

Hello, My first post, forgive me if I'm not following posting ettique/rule 100%. I have VBA code which allows me to enter data from Sheet1 to Sheet2 on the same Workbook. I need help to change the code which will allow me to enter data from Sheet1 in Workbook1 to Sheet1 in Workbook2...

To elaborate on the title, I do reporting in which the same format worksheet is emailed to me (as separate excel workbooks) from several users. It is my responsibility to summarize this data from each user into a financial report on a monthly basis. I'm trying to avoid manual data entry and...

Hi Guys, This has no code, just a lot of data. Each week I receive 20 - 30 workbooks filled with numbers that have to be added to the tally next to names on a masterlist. There are 6000 names on the masterlist, and each workbook will be adding a few to the tally next to some (but not all) of...

hi there, I have read through several threads on the use of macro to assist in extracting data from different workbook to a master file. But I can't seem to find a solution that is able to assist me. I have a total of 100 files where I will like to extract selected cells from individual file...