multiple workbooks

Hi Everyone I hope I explain my request as well. I am new to VBA and really need a solution to my problem I have searched the forums but my particular request is not found. Since I do not know how to manipulate VBA code, I would need an exact code for my particular issue. Here are the facts...

='C:\Users\Workbook\File\[00100 - Filename.xlsm]Tab View'!$T$3 This is what I currently have to utilize information from another workbook source pulling specific cells from that source into a row that is labelled "00100" (think of this as a batch number where each batch has a number of...

Off to a good start but need some help finishing this... Here's the situation: I am working between two workbooks; WB1 is used for the collection of data and although the workbook will have different data, the cells the data is entered in will remain constant, on WB2 I have 2 WSs (FPPI-Routed...

I am attempting to create an Excel file that will allow my supervisors to view the last date an employee entered activities into their excel file. A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each...

I am brainstorming on what would be the best method to compile data, but I keep finding issues with my ideas. I'm hoping some of you have a good solution I can use. Let me describe what I'm doing and looking to do. I have a large workbook that has a summary page, which uses lots of formulas to...

I collect orders through e-mailed Order Form Workbooks (file names will vary). When the order arrives, my macro unprotects the Order Form, unhides the Order Summary tab, copies the order data and activates the Order List tab in the Master Workbook, which is already open in the background and is...

Hello, I am new to VBA code and have a situation similar to one posted by DonnaJ yesterday</SPAN></SPAN> in her question "Multiple Workbooks - Can You Create Formulas Just Like When Using Mulitple Worksheets?" Fishboy responded (in part) "...Can you create formulas for multiple workbooks like...

MrExcel Forum, I have a question I was hoping someone here could help me answer. Is there a way for me to input data into the same cell across different workbooks, similar to how you would for selecting multiple sheets and adding a value in a cell (i.e., typing 5 in selected cell A2, on sheet...

Hi, I'm trying to extract data from multiple worksheets from over 30 workbooks from a same path to a another master workbook. For instance, if cell D9 in the different worksheets is equal to "X", I want to extract data from specific cells for all those worksheets. I am very new to VBA and...

As the title explains, I'm looking for code that would take data from a cell in workbook1 sheet1 and, based on a change macro I already created, populate a cell in another workbook. Specifically I need this to happen when a certain if statement is executed, but I have code for that. I'm going to...

I have a collection of CSV files in a set of subfolders and a main (but empty) file that contains formatting (column widths, colors and cell merges). I would like to copy the formatting from the formatting template xlsx file to each csv file then save the csv file as an xlsx file. I've got the...

Hi, I have a spreadsheet (call it 'Central reporting') that I want to act as a kind of central store for the first sheet (call it 'progress report') of several of workbooks which are spread around various file locations. All the workbooks have an identical layout for the first sheet; however...

I have a 2 tier problem. First, I helped to create a template with a lot of VBA work that several folks use in the field. To keep people from screwing things up, I password protected the VBA portion. Second, I need to update the footer in each of those workbooks. Each workbook has several...

Hey all, I have multiple workbooks ( Survey_RP.xlsm, Survey_CH.xlsm, etc.. They all start with "Survey" and have a "_" and then the individuals initials next to them ) in 1 file location. Inside each workbook ( They are all the same ) there is a Sheet labeled "results". In that sheet there is...

Guys, I have a workbook called "MasterSchedule" with a worksheet called "Manufacturing roster" that is updated on a normal basis. I have names listed in Column B and shifts (1st 2nd 3rd) listed in Column D. I have another workbook called "1stShift" with a worksheet called "dump" that I need...

I'm new to vba so please forgive my ignorance. I am using Excel 2010 on Windows 7. I have created a custom userform in a workbook "Assistant Hire Log - Individual". The userform works correctly in populating sheet 1 "Hire Log". Upon pushing the "OK" button, I would like the userform to also...

I'm relatively new to VBA so excuse my ignorance. I've been searching the net for the last hour for a solution to this with no luck. I want a macro that activates the next open workbook. Just say i've got 10 open workbooks, it would be nice to have somthing similar to the Alt + Tab function for...

Hello all, Long time lurker, first time poster. I'm having a bit of difficulty wrapping my head around something that would speed things up immensely for me in the office. Basically a collegue has an excel workbook and has distributed copies of to various departments for them to insert their...

Hi, I'm currently trying to write a macro to open two files and copy data from "previous" to "current". The naming convention of the files changes each week. For example, "previous" is named AR Aging 09_03_14.xls and "current" is named AR Aging 09_08_14.xls. Each time the updating process...

hey guys, i m a beginner in vba. I m having problem in upgrading my excel vba file.i made a stock data entry file in which i want that my file should create another workbook for each location while adding new location name and ignore if it has already created and add data to particular location...