multiple workbooks

  1. T

    Referencing another Workbook by using part of the filename as cell value, or...

    ='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...
  2. K

    Working between workbooks and worksheets

    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...
  3. 1

    Most Recent Date of Entry - Multiple Sheets and Books

    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...
  4. T

    Suggestions Wanted - Need to compile data for regression analysis

    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...
  5. E

    Copy, Find Row, Then Paste Between Worksheets

    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...
  6. X

    Creating Code To Populate Information From A Second Workbook With A Variable Name?

    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...
  7. T

    Data Input - Same Cell Across Multiple Sheets

    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...
  8. M

    VBA - extracting multiple worksheets from multiple workbooks to another workbook based on condition

    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...
  9. G

    VBA for writing code to copy data from one cell to a cell in another workbook

    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...
  10. J

    VBA Copy of Formatting to Files in Subfolders

    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...
  11. W

    Change all file paths in cells in sheet based on a single cell

    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...
  12. motherteresa

    2 Problems - Changing VBA password and Inserting Footer in Multiple Workbooks

    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...
  13. R

    Data ingest from multiple workbooks into a master workbook

    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...
  14. S

    Regarding Multiple workbooks... Please help!

    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...
  15. B

    Can I populate two different workbooks from one userform?

    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...
  16. L

    Cycle through active workbooks.

    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...
  17. K

    A macro to concatenate comments from corresponding cells in multiple duplicate excel workbooks into corresponding cell of one single master workbook

    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...
  18. P

    VBA-macro to open two files & transfer data (both file 1 & 2 change names each week)-need help! :-)

    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...
  19. C

    Userform Data Save in another workbook in the name of Location

    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...
  20. R

    How to Change a link address "dynamically"?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top