multiple workbooks

  1. E

    Multiple csv file import into Excel 2010. US Date issue

    Hello All, Thank you for letting me join the community, I'm pretty new to building VBA script and am attempting to import a folder of 130 odd csv files in to an workbook and then with a second macro combine them into a single worksheet. The below code is what I am using to bring them into the...
  2. L

    Please help me review my VBA code, it is not working

    <colgroup><col></colgroup><tbody> I have use a variation of this code and it will work but now I have to search for data in more than two worksheets and my variation does not work. Error starts in the first "If Not UpdateCopyPrim" Please help me identify the error in my code. Option Explicit...
  3. C

    I need to create a macro that will copy information in specific cells, then paste it into specific cells in another workbook? Is this possible?

    The workbook that I am starting in is called "Rachael" The workbook that I am trying to copy into is called "Jessica" This workbook has two tabs that I need to paste into “Summary” and “Summary Fall” The range that I need to copy the information into is: X 8:61 - "Summary"...
  4. T

    Complicated Formula - Please Help if you can!!!

    So for my current work we are getting a new system to keep track of inventory. Everything we have saved in our current inventory is saved into a workbook in Excel. I was wondering if there is a formula that can determine a few things. so the basic formula i would want would be IF A2 through...
  5. J

    VBA - Sum up cells located in multiple workbooks in one folder to master sheet

    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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top