multiple books

Hi all, I know this is very specific... I have set up tracking sheets for each of my 27 members of staff. Each of them has their own folder (which has restricted access to just them), which contains 1 work book per month for the new financial year. Each work book is identical, with a summary...

Hi - I am using the this code to copy multiple books data in to a single book and not to "re-copy" data with the same date that is already in the single book. It woks 100% and fast BUT it stop working when the data in the single book get more than 10,000 rows. Is there someone that can help...

Hi All, So a bit of vba help please and thanks! I'm looking for a macro that will copy and paste the values in a range of cell from the sheets of one workbook to the sheets of another master workbook. I want a macro that will let me select which second workbook to copy from, and then copy the...

Hello, I have downloaded a large quantity of NYSE data & would like to create a macro that allows me to compile summaries of a stock's history. The workbooks are separated by day, with each book listing the end of day data for every stock on the exchange (see below for exact format). <tbody>...

Hi all, I am very new to macro and VBA writing and see that there are a lot of very talented folks on this board who may be able to help. I have 2 workbooks I work with daily. One workbook (call it GlobalData) contains global data where any of 50+ fields could have changed each day. The second...

If I have 100 files and each one is sheet protected how do I Run unprotect sheet on all excel files (all workbook sheets) for multiple excel files in the same folder. I want to do this without having to open each excel file and unprotect the worksheets one by one... thanks I hope this is...

Hello, I have a number of workbooks each with two pages/tabs. On each of the tabs the data is identified by a unique number. Each tab has the same number of data items, located in different ranges. (e.g. sheet 1 A13:R23, sheet 2 C7:E17, in this case 10 items, in another book there may be 100...

Hi All, I was wondering if anyone could help me... I am using Excel 2003 (Work are a bit slow at moving with the times) I have a workbook consisting of mutliple worksheets which have some conditional formatting and protected cells. Each worksheet is filled out by various individuals and then...

Please I have been searching to find a helpful marco or VB script to easy my task. I am dealing with data shattered but identical source to merge them into a new workbook, then I will use this workbook as a data toward a new Management system implemented to our company. I am request to pile...