multiple workbooks

Hi! I store weekly reports in a folder. A summary excel spread sheets gets cell information form these weekly reports. I would like to use a cell in the summary report to guide which weekly report that is showed in the summary file. The link in my summary report look something like...

Hi All, I have created a macro for Consolidating the data from multiple workbooks to one master workbook. I am actually beginner for VBA. But I have referred many books and gone through websites for learning and successfully coded the below. The below VBA code which I have created is by my...

Hi everyone, Here is my problem: Lets say I have 600+ separate excel files containing 3 tabs. The primary sheet is formatted as a form that has 100 questions on it. All the sheets follow identical formatting. The idea is to have some kind of tool/function/query/macro that allows me to answer...

I created a new workbook from an existing one that adds an extra 2 sheets which both reference some of the original sheets. all of the original macros are still used for the same operation and I've added a new module with a few new macros for my two new sheets. upon opening this workbook it...

Hello. I have only been working with macros/VBA for a week, so I know there are simple issues with my code, but I've turned it into spaghetti code trying to debug. I am trying to load data from multiple workbooks into a master and really need help please!! Dir for source files: C:\Test Dir\ Dir...

Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...

Hi, I was hoping to create a pivot table from multiple worksheets that consist of multiple tabs. I am finding that I have too many elements within my data source to do this. Is there a solution other than making the world's largest master worksheet? Please advise. My elements are: Year...

Hi everyone! Hope you can help me with this as I found a code to create new workbooks but I cant's seem to bring it together. I have a workbook to create folders based on some data I paste into a group of rows. For each row it creates a folder. I got this to work quite well but now I also want...

The following Sub asks the user to select a generic template to open, then asks the user to select a source file (to populate the template). The source file is contains a number of worksheets and pivot tables. The sub then selects data from a pivot table and copies it into the template. I need...

I am looking to automate some updating that I do. I will try my best to explain. Book1: <tbody> Serial# Cycle Count Date Complete A4646366 525200 06/06/13 Done D2352352 235500 07/06/13 GC1223 667200 08/06/13 </tbody> Book2: <tbody> Serial # Life Cycle Count Last Updated...

Hi All! My problem is I cannot copy from a Form Control drop down box, and I need to do this for ~10 drop down boxes in about 200 xls files. The files follow a template so the drop down button Inputs are uniform. Here is some more detail: I’m building an Access Database so that our data...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same. Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column tabs are the same. Every workbook arrived "shared", which has created limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this when it is not...

Good Morning All! I have a good one that I am attempting to figure and then solve using VBA in Excel 2010. 11 WB's - 1 Master and 10 others which need to be updated. Master WB has 1 Sheet. Each of the other WB's contains multiple sheets. Each sheet in the WB's is laid out the same way...

I get requests from businesses around North America to have training on our products. Based on state, these training inquiries need to go to different sales reps. I was thinking, if I maintain these requests in one big workbook... is there a way to automatically link any requests for e.g...

First timer on the forums, so bare with me please :). I have several .txt files in one directory. I want to import each .txt file into an Excel template. Then save each as its own workbook. This template formats and has formulas to convert the .txt data to data I need. I also want to save the...

Hi there, I have a macro that generates multiple Excel sheets by looking at data on one sheet and then setting the values in a template accordingly (not copy/paste, but Worksheet1.Range(ABC123).value = Datasheet1.Range(XYZ789).value). The macro runs without issue across multiple PCs and...

Hi, I am new to this forum! I am trying to understand whether the following scenario is possible.. I use SharePoint at work to allow multiple users to view spreadsheets. Is it possible to have a workbook uploaded to SharePoint pull information from other workbooks uploaded to SharePoint? My...

I have a daily workbook that consists of three sheets. One of the sheets is a productivity log for that day. The workbook is saved via an existing script to create the names using a consistant format which is dd-mmmm-yyyy filename.xlms. At the end of every month, the data from these workbooks...

Hi Everyone Please can someone help me? I'm a complete novice with VBA but I really need a macro for work. I have a master spreadsheet eg: <table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="3"> <colgroup><col width="86"><col width="86"><col...